How to allow users to successfully use a split Access 2007 Database
Posted on 2009-12-16
I have a small database that I have split on an XP Pro network. All users have Modify or greater permission to the database. I have left the back end of the database on the network share that they have permission to. I have copied the front end of the database to my desktop and to their desktop. I have verified that I am not opening it exclusively and that in Access Options, Advanced and under Advanced, "Shared" is selected in default open mode and "Edited record" is selected under default record locking.
I can successfully open the database front, view records, make changes, and run the macro. When I have another user open the front end database, they can successfully open it (while I have it opened), but cannot run the macro, or view the forms, or reports, etc, without getting a "file is already in use error."
I split the database to allow users to enter data and view reports, but cannot get past this hangup. Please help! I am on standby and should be able to respond very quickly.