Publishing database for multiple users.

  • Thread starter Thread starter Festo Database
  • Start date Start date
F

Festo Database

I have my recent database published on a shared drive that all potential
users can get to. I have already split the database (per Inside Out book Ch.
25), but when more than one person tries to use it, they cannot get in. They
only get an hour glass and then nothing happens. I don't what to do. I need
up to 15 or 30 to be able to access the one form at a time. Any help would be
great.
 
Anyone trying to use the data on that network share must have read-write
permissions on that folder. Have your network folks confirm that all users
have those permissions.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Does each user have their *own* copy of the front end,
preferrably on their local drive?
 
They do not. They have an icon to get them to the shared drive. If they have
a copy on their local drive, would the info get sent back to the Tables?
 
Yes.

The recommended approach is for each person to have his/her own copy of the
front-end, preferably on his/her hard drive.
 
would the info get sent back to the Tables?

Yes.

The way you are handling it now (having multiple users share
the same front end) is widely regarded as one of the leading
causes of corruption in Access.

The proper way to set up multi-user with Access is to place
the back end on the server and give each user their own
copy of the front end (again, preferrably on their local drive).
If you use UNC path naming (rather than drive letter path
naming) for the link to the back end then the same path
should be valid from all locations.

I would also make a MDE copy of the front end and give the
users that (instead of a MDB copy). Keep the MDB as a master
for future design changes. Also, as Jeff said, all users need
full permissions on the back end folder.

All of this assumes you are working on a LAN (not a WAN)
If you are on a WAN, you can check out Albert Kallal's web
page for alternative options;

http://www.members.shaw.ca/AlbertKallal
 
Back
Top