access 2007 locked

Question

I'm connecting the access 2007 database from 5 different machines. (C#.Net)

I'm having this error message:

The database has been placed in a state by user 'Admin' on machine XXXXX that prevents it from being opened or locked

Answer 1

This means that someone is editing one of the database objects, like adding a field to a table or creating a new query or similar, in short they have something in the database open in editing mode.

Answer 2

Access databases should be split into front-end for forms, reports, code etc, and back-end for tables.

The back-end should be placed in a directory with a minimum of read and write permissions, otherwise the lock file (ldb) can get locked up.

Each user should have a copy of the front-end.

Answer 3

you can copy the access file and operator it ,try it?