Is a table locked?

[PearlGI]

Is it possible to detect if a table is locked (i.e. a query, report or form using a table is open).

I'm trying to automatically delete selected tables on a periodic basis, but the code falls over if the table is currently in use.

How can I trap for this so the delete line can be skipped?

 

[pdx_man]

Check out the OnError Access Help file to trap the error. If it is the error that you describe, then use the Resume Next Statement.

 

[PearlGI]

Thanks, that does the trick.