By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,687 Members | 2,046 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,687 IT Pros & Developers. It's quick & easy.

Access database sharing on windows 2000 PC

P: n/a
Having problems sharing an Access database on a Windows 2000 PC. The
other PC is windows 98 (as I recall) but NOT windows 2000!

The 2nd PC has a shortcut to the MDB on the primary PC.

The MDB can be opened - 1 user at a time.

The MDB Options - Advanced -
Default open mode = shared
Open databases using record locking is checked
Default record locking = edited record

The directory containing the MDb is set for sharing for Everyone and
security allowing full access for Everyone.

It appears that when the 2nd PC connects, it opens the MDB exclusively.

Suggestions?

Bob
Apr 25 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Bob Alston wrote:
Having problems sharing an Access database on a Windows 2000 PC. The
other PC is windows 98 (as I recall) but NOT windows 2000!

The 2nd PC has a shortcut to the MDB on the primary PC.

The MDB can be opened - 1 user at a time.

The MDB Options - Advanced -
Default open mode = shared
Open databases using record locking is checked
Default record locking = edited record

The directory containing the MDb is set for sharing for Everyone and
security allowing full access for Everyone.

It appears that when the 2nd PC connects, it opens the MDB exclusively.


Split the database. Each user should have a copy of the front-end (the
queries, forms, reports, macros and modules) on their PC. The back-end
(the data tables) should be on the server or shared PC.

To split a database use the menu items:

Tools > Database Utilities > Database Splitter

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Apr 25 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.