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
|
|||
|
|||
Share a Db
I am using Access 2003
I created a database for a PM Program that sometimes requires more than one person to use the program at the same time. Is there a way to allow this to happen. I did go into Tools Options Advance tab and make the "default Open Mode" shared. But if an employee is using the program, I still get a message that if I make changes to the program, they will not be saved because someone else is using the program. Can anyone help me or point me in the right direction???? Thank you - Aurora |
#2
|
|||
|
|||
Share a Db
"Aurora" wrote in message
... I am using Access 2003 I created a database for a PM Program that sometimes requires more than one person to use the program at the same time. Is there a way to allow this to happen. I did go into Tools Options Advance tab and make the "default Open Mode" shared. But if an employee is using the program, I still get a message that if I make changes to the program, they will not be saved because someone else is using the program. Can anyone help me or point me in the right direction???? Thank you - Aurora You need to split your app and give each user their own FE. More info he http://www.granite.ab.ca/access/splitapp/index.htm Keith. www.keithwilby.co.uk |
#3
|
|||
|
|||
Share a Db
1. All users of the database must have at least read, write, create, delete
(or modify) privileges to the folder holding the database file. Not just the database .mdb file, but the entire folder. I'm betting that this is the problem. 2. Open the database and go to Tools, Options, and Advanced Tab. Set the Default Open mode to Shared and the Default Record Locking to Edited Record. (While you are in the Options area, go over to the General tab and turn off Compact on Close and Name AutoCorrect. Trust me on this.) 3. You can also get this error if someone has a form, report, etc., opened in design view. Early versions of Access would allow someone to make design changes while others are using the database; however, newer versions limit this ability. It's another good reason to split the database so that you can do development on a copy of the Front End and put it into production easily. Sure beats working midnight shift when the users aren't around! 4. It’s possible that someone has manually opened the database exclusively. In that case go to the folder holding the .mdb file and open up the same named .ldb file in Notepad. You might be able to read which users are in the database and locked it. Apply 2”x4” as necessary to user. However that should give a "file already in use" error. To stop this from happening create a shortcut for each user on their desktop or off the Start button. It should list the target as the database file and look something like: "P:\Databases\Database File.mdb" 5. To open exclusive use the following in a shortcut: Make sure that the path, version of Office, and database name are right: "C:\Program Files\Microsoft Office\Office11\MSAccess.exe" "C:\Program Files\Microsoft Office\Office11\Samples\Northwind.mdb" /excl You can also open up Access by itself; go to File, Open; select your database in the Open dialog box; then go to the lower right of the dialog box and change Open to Exclusive. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Aurora" wrote: I am using Access 2003 I created a database for a PM Program that sometimes requires more than one person to use the program at the same time. Is there a way to allow this to happen. I did go into Tools Options Advance tab and make the "default Open Mode" shared. But if an employee is using the program, I still get a message that if I make changes to the program, they will not be saved because someone else is using the program. Can anyone help me or point me in the right direction???? Thank you - Aurora |
Thread Tools | |
Display Modes | |
|
|