Loosing exclusive access somehow

[Guest]

I start with exclusive access, but after my forms close I can't make edits
because I no longer have exclusive access.

(1) In my code, I close all objects I open, and I set them to nothing.

(2) No one else is opening the database.

(3) The .ldb file is created/destroyed at each open/close respectively.

Am I overlooking some code? or is something else causing this.

Thanks
David Mueller

 

[Guest]

Hi, David.

Am I overlooking some code?

Probably. Is your code opening any other Database Objects within the same
Workspace Object? Is your code modifying any CommandBar Object?

If you can't find any culprits in the code, then use the LDB Viewer to watch
for when your workstation connects to the database file a second time,
thereby puting the database in shared mode. Perhaps you can backtrack from
there and determine what action caused the second connection.

Please see the following Web page for links to the free LDB Viewer and other
free diagnostic tools in the "Free Microsoft Access Troubleshooting Tools"
section:

http://www.Access.QBuilt.com/html/links.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

 

[Guest]

Indeed I am. Thanks. I found it.

I created a new workspace object, and now it's all good.