CODEWITHSUNDEEP
c#.netms-accessms-access-2007
Mehmet
Mehmet

Reputation: 2278

access 2007 locked

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

Upvotes: 2

Views: 605

Answers (2)

Fionnuala
Fionnuala

Reputation: 91306

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.

Upvotes: 0

Coding Flow
Coding Flow

Reputation: 21881

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.

Upvotes: 2

Related Questions