Re: Can I link to an mdb in a Web Folder?



bcanavan@xxxxxxxxxxxx wrote:
> I'm trying to link a remote client Access app (through the internet)
> to an mdb in a web folder on my web server. The idea is to give users
> readOnly access to the web folder mdb, which itself links to SQL
> Server 2000. Users are not permitted to connect directly to SQL
> Server because it's outside our dmz.
>
> I have succesfully created a WebDAV on our Win2003 Server web server
> and granted readOnly permission to the users, who are listed in Active
> Directory.
>
> I have also succesfully created the web folder (in Network Places on a
> Win2000 test client pc) which points to the web folder on the web
> site. The web folder itself is visible to the client, but no files
>
> I'm stuck though when I try to map a logical drive to the web folder,
> or when I alternatively try to create an odbc connection, on the
> client pc.
>
> As I understand it, WebDAV is supposed to expose the files in the web
> folder on the web server, and allow file transfers between the two
> computers using port 80(http).
>
> Am I wasting my time?

Yes.

Can this be done at all?

No.

To be able to link to an Access file you have to be able to browse to it in
the regular file system. In other words if you can't see the file in
Windows Explorer then you can't link to it. That cannot be done over HTTP
as far as I know.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.



Relevant Pages

  • web service overwriting web app folder
    ... Use IIS Web server, with Project URL: = http://localhost/epnuc ... web folder when I have explicitly set them to be in different web folders as ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Web Folder keep asking for user password.
    ... "Hadi" wrote in message ... > I have a directory in the web server that I set as web folder the idea is ... Tom Kaminski IIS MVP ...
    (microsoft.public.inetserver.iis)
  • Can I link to an mdb in a Web Folder?
    ... readOnly access to the web folder mdb, which itself links to SQL Server ... I have succesfully created a WebDAV on our Win2003 Server web server ... Win2000 test client pc) which points to the web folder on the web site. ...
    (comp.databases.ms-access)
  • Web Folder keep asking for user password.
    ... I have a directory in the web server that I set as web folder the idea is ... like a WebDAV folder. ... Hadi ...
    (microsoft.public.inetserver.iis)
  • Re: Modify Forms in Separate MDB
    ... Now that I understand your reasoning, I would suggest you begin to look for ... distributed via XCOPY and thier web server must always be up. ... > Reasons the client does not want to send out new versions ... > programmatically change forms in one MDB from another MDB? ...
    (microsoft.public.access.modulesdaovba)