0

My two databases(.mdb) are placed at a network shared folder.

Now at the same time few users are connected to database from the network place and doing their job.

In the middle get the error like :

error 1 : "The database has been placed in a state by a user "Admin" on machine "machine no." that prevents it from being opened or locked." 

error 2: “Cannot Open Database”. It may not be a database that your application recognizes, or that file may be corrupt.

can anyone please suggest me how i can open this database in programatically, so that different users can run their own application simultaneously without any error.

siba
  • 1
  • 1
  • 1

2 Answers2

2

Since you mention that several users are working fine for a while, you have the database configured for multi-user Shared access.

However, apparently someone on "machine no." is able to acquire Exclusive control of the database. The errors you are getting are the fallout from the Open Exclusive and likely does not indicate any corruption.

This suggests that you also need to configure the security for the database to deny your users the Open Exclusive permission.

There once was help on this at this at a now defunct link. For what it is worth, you can examine: http://traycare.com/Help/NtwrkOps.htm and see if it helps you.

EDIT: Note that changes to the database structure (Forms, Views, Tables, etc) require Open Exclusive and should be scheduled for a maintenance window so as to avoid unnecessarily interfering with users of the database.

RLF
  • 14,035
  • 2
  • 34
  • 47
0

Access is not very good as a multiuser database. You might want to move the tables into a mySQL database, for example and then link the tables to the database using ODBC. SQL Server or Oracle would work as well. It allows you to use the forms, reports, etc without having the data in Access.

Gandolf989
  • 1,540
  • 1
  • 13
  • 18