Table is locked by another person or process??

[John Dumay]

Hi,

I am running code to update a table when I open a form. Nothing that I can
see is open and I am sure I don't have a recordset open that uses the table.
When I try to access the table I get

Run-time error '3211':

The database engine could not lock the table 'tblSurveyDataSet' because it
is already in use by another person or process.

How can I check for open connections to a data base and if there are any
close them down so my code will run?

Any help is, as always, appreciated.

Regards,

John Dumay

 

[a a r o n . k e m p f]

yah no shit

Jet has locking problems, front end / back end doesn't help it.

It makes a lot more sense to anyone with _ANY_ professional software
development skills or experience-- to move to SQL Server.
you shouldn't have to deal with connection strings every 5 mins.

you shouldn't have to kick out your users for a compact & repair.

upsize to ADP and your troubles are gone.

no more auto-fe-updater-- you can edit data or or tables or queries,
and they automagically show up for your end users.

-Aaron

 

[Clifford Bass]

Hi John,

It could be caused by what you are doing in code. How about posting
the relevant code?

Clifford Bass