I am creating a database in Access 2003 for multi-users. However, when my co-worker and I both try to open it one of us receives the following error:
("The database has been placed in a state by user <name> on machine <name> that prevents it from being opened or locked")
I have done some research on this error and seen that a lot of people suggest splitting the db to a FE and BE. I have created db's like that in Access 97 (we are a bit behind with technology unfotunately) and everyone can get into them just fine but I think that is more due to the security .mdw file we have set up with that Access 97 db.
All the threads I read about the above current error in 2003 say that you then have to place the FE copy on all users PCs. But I am confused as to how they will then get any changes or updates to the db if they don't constantly add the new FE to their PCs?!?!!?
Any assistance would be much appreciated as our deadline for creating this db is nearing! Is there another way around this error?
Thanks,
Amy