If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Publishing database for multiple users.
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. |
#2
|
|||
|
|||
Publishing database for multiple users.
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 "Festo Database" Festo wrote in message ... 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. |
#3
|
|||
|
|||
Publishing database for multiple users.
Does each user have their *own* copy of the front end,
preferrably on their local drive? -- _________ Sean Bailey "Festo Database" wrote: 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. |
#4
|
|||
|
|||
Publishing database for multiple users.
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? "Beetle" wrote: Does each user have their *own* copy of the front end, preferrably on their local drive? -- _________ Sean Bailey "Festo Database" wrote: 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. |
#5
|
|||
|
|||
Publishing database for multiple users.
Yes.
The recommended approach is for each person to have his/her own copy of the front-end, preferably on his/her hard drive. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Festo Database" wrote in message ... 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? "Beetle" wrote: Does each user have their *own* copy of the front end, preferrably on their local drive? -- _________ Sean Bailey "Festo Database" wrote: 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. |
#6
|
|||
|
|||
Publishing database for multiple users.
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 -- _________ Sean Bailey "Festo Database" wrote: 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? "Beetle" wrote: Does each user have their *own* copy of the front end, preferrably on their local drive? -- _________ Sean Bailey "Festo Database" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|