link to database over intranet

[barkingpenguin]

Hello folks:

I have placed a split db on an IIS (2003) server at:

e:\inetpub\wwwroot\backend.mdb

The front-end db is kept in the same location. On the local intranet site I have created a webpage with a link to the front-end which works fine, but when I try to use the db over the intranet Access tells me that the path to the tables is invalid, even though it correctly reports the path as:

e:\inetpub\wwwroot\backend.mdb

I suspect the issue is that the path should be something like: ../backend.mdb but I can't find how to manually create this using the Linked Table Manager or Import -> Link Tables. The weird thing is that I tried this same scenario on my home network and it works just fine. The only difference is that I have Server 2000 at home and almost zero security set up.

Does anyone have any thoughts on how to get this working? I know that I can just push the front-end files to user's desktops, but the client would really like to have a link from the intranet site so that any PC on the network can access the files.

Thanks for any help!

 

[KenHigg]

You may have to replace 'e:' with the sever name.

Change:

e:\inetpub\wwwroot\backend.mdb

To:

\\mysevername\inetpub\wwwroot\backend.mdb


I haven't tried it this way but maybe it'll work...

kh

 

[barkingpenguin]

Thank you Ken.

That did the trick. I had to browse to the network location in the Linked Table Manager.

 

[KenHigg]

Just curious - Is it letting you write back into the inetpub\wwwroot folder?

kh

 

[barkingpenguin]

Well, actually, I changed that. I ended up placing the db in a shared folder on the server and having the users download the front-end from the intranet site.

It would be cool if they could just click a link on the website to open the front-end, but the browser won't open the file without asking to save or open. They can select the option to not ask, but we're talking about users here....

Also, windows XP with SP2 doesn't even let them open the file because it is a security risk, so....

Do you know if there is there a way to achieve opening the db from a weblink?

Thanks again,

 

[KenHigg]

Actually I have that same problem...

Maybe someone else will have some advice....Seems there'd be a pc of script you could use to do that...

kh