CODEWITHSUNDEEP
ms-accessms-access-2007
IMHO
IMHO

Reputation: 799

Configuration can't save design changes or save to a new database object because another user has file open

I have a MS Access database with few tables and a form. When more than one user tried to save changes to data - I get this error:

"Configuration can't save design changes or save to a new database object because another user has file open"

Not sure why this is happening, since the design is not being changed just a data.

Any thoughts?

Upvotes: 0

Views: 1560

Answers (2)

Fionnuala
Fionnuala

Reputation: 91376

It is recommended to split databases in multi-user environments. This will allow you to develop on a copy of the front-end and then circulate it to the users.

http://msdn.microsoft.com/en-us/library/aa167840(office.11).aspx

Upvotes: 1

extraneon
extraneon

Reputation: 23960

I googled and it seems you have to split the database in a front-end per user and a backend containing (only) the data.

Upvotes: 1

Related Questions