If I have multiple users that try to access the database at the same time, the second user gets the following message:
"you do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later."
I have done a lot of reading on the topic and have not found a solution yet. From the other threads that I have read, here are some answers to the questions that I kept seeing.
1) yes, the database is split into front and back ends
2) I have checked the computers of the users and they are setup in their options to open the database as shared, not exclusive
3) The database resides on a company network. The users are opening the front end application directly. When the database opens, there is an autoexec macro that basically opens a switchboard. Not data entry on that screen, just buttons.
4) there are no security groups or anything setup, anybody can access the front end if they know where it is
5) I do not have any stuck record locking files sitting in the directory. They disappear when the user exists the file.
I hope that someone can help me out, this is the last major hurdle for me to go live.
Thanks
Chris