Discussion Locked

.MDW file already in use must die

0 helpful
8 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have Access97 on a stand-alone server. The database & wrkgroup file are on a shared drive with 8 users all having read/write permissions. Problem: First user to the database locks all other users out, including administrators(me)having full-control. I've verified no one has exclusive mode checked. I have configured DCOM for interactive user. I have set permissions in the specific database for read-only. I've set the records options to NO LOCKS. We still can't get more than 1 user at a time in this database. My inclination is to do away with an active database and provide a read-only copy for the users, but superior powers insist on having "live" access for all users. This is a gotta get fixed--and soon problem. (Notice the pointvalue)

8 replies

by stillatit

There are two ways to deal with this.

1. Each user has their own copy of the .mdw file (the security file) on their local disk. The command to start access must use the switch which specifies the location of the .mdw file.

2. Each user has both their own .mdw and their own .mdb (database) file. The database file has linked tables to the main file.

Good luck.

by shanghai sam

I tried both your methods; niether one produced acceptable results. I have one of ten workstations which can access the database at the same time the local server has the database open. That computer is my desktop machine. It has admin rights with the database, which appears to be the only difference to the other workstations. We cannot have ten workstations all with admin permissions--that would be somewhat self-defeating.

by curacao_dejavu

Access 97 allows for replication:
Improved replication Improved replication features enable multiple
users from remote locations to update and work with the same data and synchronize any changes, even across the Internet.

See the mskb Q136134 for How to Make a Database Replicable.

Q90851 leads me to believe you can install acces97 also in a multiuser installation.
But I do not know how to do that.
regards,

Leopold

by don christner

To use Access in a multi-user environment, when you install Access you must use the /N option. This tells Access to install in a multi-user environment (over a network). If you do not use the /N option, Access will not share access to the data.Look in the Access users guide under "setting up Access on a network".

Don

by shanghai sam

This method doesn't help. I have one of ten workstations which can access the database at the same time the local server has the database open. That computer is my desktop machine. It has admin rights with the database, which appears to be the only difference to the other workstations. We cannot have ten workstations all with admin permissions--that would be somewhat self-defeating.

by dbakp

Point value changed by question poster. I am confident that someone out there has had this tribulation and solved it without replicating their database.

This discussion is closed to new replies.