Opening Database over company LAN

[ramkv]

Dear Sir,

I have created a Database along with user profiles for access types (RO,RW etc) in my PC. I am able to open the database using the shortcut created automatically for the wrkgrp. But problem comes when I try to access the database from another PC in the LAN I get a message"MS Access cann't find database file "D:\material\in dent.mdb
I am using MS Access-2003.

[NeoPa]

My guess is that you have a Back End database (at D:\Material\Ind ent.mdb) which is not available to the person accessing it over the LAN.

Every linked Access/Jet BE database is opened directly from the user's PC, so however the link is specified, it must be accessible from all users who try to use it.

[jimatqsi]

D:\ is almost certainly a local drive on your PC. Other PCs are going to have their own D:\ which is surely different from yours. You really need to put this on a shared network folder or mapped drive somewhere.

If you have not done this with a front-end and back-end as NeoPa suggested, you definitely should. A lot of people will just put the entire thing in one .mdb and put it on a shared drive. It will seem to work okay but unexplained glitches will occur. Save yourself the grief.

Put the tables in a separate .mdb (back-end) which goes on a shared drive, and all the forms, queries, macroes in a separate .mdb (front-end). Link the front-end to the back-end tables. Then give each PC their own copy of the front-end.

Jim