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.