I run a lot of MS Access forms and reports at work and many people run them at the same time.
Gererally I will create a shortcut to the specific MDB/form/ect.. and the user will click on the shortcut and the application will open, or that is what used to happen.
Now if another user has the application open the only way for the second user in to have the application open is to go to MS access> File> Open and then select the shortcut. Which equals broke to some users
It has not always been this way it seems like maybe a year ago this started.
Microsoft Legacy OSMicrosoft ApplicationsMicrosoft Server Apps
Last Comment
Jerry Miller
8/22/2022 - Mon
Jerry Miller
A better way to do it is to split the back end data tables from the front end forms.
http://office.microsoft.com/en-us/access-help/split-an-access-database-HA010342026.aspx
But if I have multiple users, i try to put it in a web app with a real database back end (MS SQL, MySQL, Oracle, )tc