My DB is split into a back-end & front-end. I convert the fe.mdb into an MDE file that is distributed to the users' desktops. The users don't ever work directly in the fe.mdb. I've recently encountered a strange problem in the fe.mdb when I try to make updates. I get an error stating:
"The database has been placed in a state by user 'Admin' on machine 'MY COMPUTER!' that prevents it from being opened or locked."
I'm locking myself out! Here are some of the ways I've been troubleshooting:
1. When the switchboard loads, it opens all of the tables in the be.mdb to improve performance. I've tried closing the switchboard to close the constant connection. No avail.
2. I thought that perhaps I could fool the system by making the fe.mdb exclusive access instead of shared. No go.
3. I've toyed with the idea of setting the security levels, but the research that I've done on security settings don't seem to apply to my problem.
What am I missing?
Thanks in advance!
"The database has been placed in a state by user 'Admin' on machine 'MY COMPUTER!' that prevents it from being opened or locked."
I'm locking myself out! Here are some of the ways I've been troubleshooting:
1. When the switchboard loads, it opens all of the tables in the be.mdb to improve performance. I've tried closing the switchboard to close the constant connection. No avail.
2. I thought that perhaps I could fool the system by making the fe.mdb exclusive access instead of shared. No go.
3. I've toyed with the idea of setting the security levels, but the research that I've done on security settings don't seem to apply to my problem.
What am I missing?
Thanks in advance!
