A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Share a Db



 
 
Thread Tools Display Modes
  #1  
Old October 20th, 2009, 03:19 PM posted to microsoft.public.access.tablesdbdesign
Aurora
external usenet poster
 
Posts: 224
Default 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  
Old October 20th, 2009, 04:43 PM posted to microsoft.public.access.tablesdbdesign
Keith Wilby
external usenet poster
 
Posts: 812
Default 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  
Old October 20th, 2009, 05:06 PM posted to microsoft.public.access.tablesdbdesign
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.