Table in use by another person or process

[teqtaq]

I am having a Report based off of Oracle view that linked into Access dtatbase.
I wrote Select, Crosstab and Make Table queries for this Report.

When I want to run this Report for the second time I am getting a messg that sysem can not lock table XXX because it is in use by another user or process. And there is no one but me who knows about where Reprot is. Closing and re-opening .mdb will not help the issue.
After some 30 min or so I can run Report again. I am looking for the properties that maybe holding connection. I need to break it.

I was told to create table in VBA and kill it after each use. Do you agree?
And how difficult is it?

Thanks so much.

 

[ZmrAbdulla]

Not a reply to your question but..
Passthrough queries are meant for this purpose. So that you don't have to link the table
here you go

http://support.microsoft.com/kb/303968

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[teqtaq]

Thanks.
I solved it by creating APPEND qry insted of Mke Table one...go figure!