Access database sharing on windows 2000 PC

[Bob Alston]

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

[MGFoster]

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)