We have been using an Access dB for MRP that was built 15 or more years ago. I rebuilt the database to optimize/update macros, reports, etc. It works great.
Typically, we will have up to 5 users in the database throughout the day. with the old database, the only time you would receive a message about exclusive access would be if you were trying to change a report, query, table or macro. With the new database, anytime a second user opens the database, the 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."
This is not a show stopper, but an aggravation I would like to resolve.
Any suggestions appreciated.