tags:

views:

93

answers:

2
Q: 

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?

+1  A: 

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

extraneon  2010-04-21 19:52:42
well, I googled the hell out of it and didn't come up with any other solution. It does make sense since ldb file would be locked and if two users open from same location - can't touch ldb file
IMHO  2010-04-21 20:13:15
+1  A: 

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

Remou  2010-04-21 19:52:51
this is good point but it's not an option at this time. Any other ideas?
IMHO  2010-04-21 20:00:42
Have you added acSaveYes to Form close? You should not do this as it saves the form, not the record and is therefore regarded as a design change.
Remou  2010-04-21 20:22:32

related questions

MS-Access design pattern for last value for a grouping
Best way to test a MS Access application?
How would you migrate hundreds of MS Access databases to a central service?
Is there anything wrong with this query?
Read Access File into a DataSet
MS Access Reporting - can it be pretty?
Import OLE Object from Access to MySQL
What's the best way to work with SQL Server data non-programmatically?
Is there a way to get ms-access to display images from external files
Using MS Access & ODBC to connect to a remote PostgreSQL
File database suggestion with support for multiple concurent users.
Delete Records from Access database, error while deleting
Converter for VB.NET Code to Linux Platform Exist?
Performance issues regarding Access 2003 and the OLE Object data type
Java code to import CSV into Access
Can you use LINQ tools such as SQLMetal with an access database?
Good Free Alternative To MS Access
Can DTS Test for Presence of MS-Access Table
How to filter by 2 fields when loading data into an access database table from an excel spreadsheet
Any tips on getting Rails to run with an Access back-end?
Disabling multi-line fields in MS Access
Access 2000 connecting to SQL Server 2005
Building an auditing system; MS Access frontend on SQL Server backend.
Is there a way for MS Access to grab the current Active Directory user?
Issues using MS Access as a front-end to a MySQL database back-end?