Table in Use

[feebert]

I have an Access97 database that links 2 other databases together. I then have a form that runs on the timer event and runs queries at certain intervals.

I am also using the "DoCmd.OpenQuery" to run the queries on the interval.

My issue is when I open one of the databases and open a certain form it tells me that its in use by user "username" and cannot continue.

Long story, but I need to know if there's a way to diconnect from this table. Don't forget, I'm using DoCmd.OpenQuery therefore I didn't see a need to use the "Set DB= Nothing" or "Set rst=Nothing". I also tried setting the DB and the RST to Nothing but it didn't help.

Thanks in advance
Jack

 

[boblarson]

Is your form bound to the table that you are trying to run the query on? And, what type of query are you running?

 

[feebert]

Thanks for the reply Boblarson, I just figured out.

Thank for your response