Novice
Windows 7 32bit 
Access 2010 32bit
Hi
I have developed a simple database in version 2010 with few Forms using VB script. The main Form contains few navigational buttons to call for changes on subforms located in the center of mainform. I have successfully split the database and distributed Front-end copies in a shared drive. However, I am still having multi-users access issue.
If anyone could help out it would be greatly appreciated.
Access Developer
Windows XP Access 2003
The Backend should be in a shared drive. Each user should have a copy of the Frontend on their own machine which should be linked to the single Backend.I have successfully split the database and distributed Front-end copies in a shared drive.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Novice
Windows 7 32bit Access 2010 32bit
yes, the backend is also located in the shared drive and those users also have the same access rights to the folders.
To be exact, the main Form seem to be okay with distorted layout but the subForm's area is blank.
The subForms being called are displayed in datasheetview and I am not sure if the issue is that the subform is maintaining connection to the tables.
Access Developer
Windows XP Access 2003
Does each user have a copy of the frontend on their own machine?Originally Posted by rustyroy
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
Novice
Windows 7 32bit Access 2010 32bit
The users are running it on the shared drive.
Access Developer
Windows XP Access 2003
Well the first thing to try, is setting it up properly, with each user having a copy of the frontend.
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
Access Developer
Windows XP Access 2003
Cross posted. See: http://www.access-programmers.co.uk/...d.php?t=247698
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
Novice
Windows 7 32bit Access 2010 32bit
yup.. just want to maximize the exposure and knowledge sharing always help us to become better.
Access Developer
Windows XP Access 2003
Cross-posting on different forums without notification is not a good idea.
Read this: http://www.excelguru.ca/content.php?...-cross-posters
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
Novice
Windows XP Access 2007
I use an .mde format (on the front end) Try changing the format just by changing the front end from .accdb or .mdb to .mde
I also use one front end on a citrix server that everyone uses so that shouldn't be a problem.
Multi User Access Database 2010 couldn't lock file error
Multi-User Access
Posting Permissions
Reply With Quote