Posted 30 July 2009 - 08:09 PM
I have several Access database files on a network server. The Access database files were created in Access 2003/XP. The database files are access by two users. One user has Office 2007 and the other has Office XP. Occasionally, when the user who has Office 2007 opens a database file, it is Read Only... (This recordset is not updatable. You must save a copy). For this user, all database files also opens as Read Only. Before the Office 2007 user can make changes or update data, a copy of the database file must be saved. This must also be done for each database file on the network that this user accesses. Over the past 6 months, I have saved the database files (with a different name) a few times. After which, the database files are OK until a month or so later. The user with Office 2003 doesn't experience any probems with the database during the time.
I have done some searching on the particular problem but haven't found much. Much of what I found was make sure the file(s) are not marked read only and the locked file for the database was not still active. I've checked each time and the files are not read only and the locked database files were not hung up.
The other user is always able to access and update the database files without any problems.
Is there something in Access 2007 that I am missing or don't have set properly?