Other Database Users

[timmus02]

I have copied my database and external files to my employers server. All external files open correctly for me, but other users can not open the external files, but the forms work. I have attempted many ways to resolve this but have had no success.



Also, is there a way that more than one user can access the database at the same time?

[andy49]

Also, is there a way that more than one user can access the database at the same time?

Is the database split? Frontend for each user and Back end (tables etc) in one place.

but other users can not open the external files

Is the database referring to Local areas to get the external files - So eg if the db was referring to server:\\yourarea\file.pdf then the db wouldn't be able to get to this file for another user.

 but other users can not open the external files, but the forms work

[John_G]

What kind of "external files" are you referring to? If they are other (tables in) other Access Databases, you can just re-link them.

If they are text files, or images, or other non-database files, my guess is that you have hard-coded the paths to them in your VBA code, and you will have to modify the code to use the new paths. For example, perhaps during development you were using files on your own local hard drive, so the references will have to be changed to the network drive.