Opening microsoft access from multiple locations
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.
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.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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
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
It probably would because you would no longer be using a shortcut to one MDB file. Each user would have a copy of the front end application. Of course this is only a viable solution if you don't have too many people using the application since every change requires distributing a new copy of the front end.
If you issue started a year ago, I am not sure that you can track down the root cause unless you have fantastic records pertaining to all of the patches, updates, etc that have been performed on the affected computers.
That being said. Check under Tools>>Options>>Advanced and make sure that your "Default Open Mode" is set to Shared and the "Default Record Locking" is set to No Locks, with the checkbox for "Open database using record-level locking" is checked.
If you issue started a year ago, I am not sure that you can track down the root cause unless you have fantastic records pertaining to all of the patches, updates, etc that have been performed on the affected computers.
That being said. Check under Tools>>Options>>Advanced and make sure that your "Default Open Mode" is set to Shared and the "Default Record Locking" is set to No Locks, with the checkbox for "Open database using record-level locking" is checked.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial