Computing.Net > Forums > Office Software > multiple access to Access database

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

multiple access to Access database

Reply to Message Icon

Name: clubjunkie
Date: April 16, 2005 at 17:22:46 Pacific
OS: XP
CPU/Ram: 512
Comment:

I have a client with one server and four or five workstations...On the server is an Access databaes i built for him, containing all of his clients details. each member of staff (at the workstations) needs to access this database at the same time, as they are all working off the same list and need to keep them synced up. the first one to open the file is ok, but thereafter the others get a Read-Only warning when they open it, making it all but useless to them. Is there anyway I can let them all use the same file at the same time and have the saves they each make all go back to the main file? i am running out of time on this, and am eager to get it fixed asap. Hopefully i have made the prob clear...

faster, better, MORE!!



Sponsored Link
Ads by Google

Response Number 1
Name: smithdk
Date: April 16, 2005 at 21:16:27 Pacific
Reply:

Is the database being opened in exclusive or shared mode?


0

Response Number 2
Name: clubjunkie
Date: April 20, 2005 at 02:13:47 Pacific
Reply:

Well, i dunno, as this isn't really my bag. It was put on the server and each member of staff is tryign to open it at once as all i know, dave. I pretty much handed it over to them once I had completed the thing itself. if you have any advice, that'd be great

faster, better, MORE!!


0

Response Number 3
Name: smithdk
Date: April 20, 2005 at 17:27:43 Pacific
Reply:

Check on the options settings in the database. There is one for shared or exclusive when it is opened.


0

Response Number 4
Name: clubjunkie
Date: April 21, 2005 at 14:20:07 Pacific
Reply:

coolest of the cool. thanks Dave.

faster, better, MORE!!


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: multiple access to Access database

Alternative to access database www.computing.net/answers/office/alternative-to-access-database/1857.html

Link Access fields to SQL Database www.computing.net/answers/office/link-access-fields-to-sql-database/1075.html

trouble opening access database www.computing.net/answers/office/trouble-opening-access-database/1641.html