The database engine could not lock table (error 3211)

[Brian Camire]

Installing Microsoft Jet 4.0 Service Pack 5 (SP5) or later may solve this
problem. With versions of Microsoft Jet 4.0 (which Access 2000 uses) prior
to this, an exclusive lock is placed on dBASE files. This will cause the
error you are getting. For more information see Microsoft Knowledge Base
230125, titled "ACC2000: Using dBASE Data with Access 2000 and Jet" at

http://support.microsoft.com/default.aspx?scid=kb;en-us;230125

 

[David Fazenbaker]

In my database, one of my tables is actually a link to a
dbase table.

I have 3 queries that I use to gather 3 different kinds of
data from the dbase link table.

I have 3 subreports and each one is linked to one of the
queries. Each subreport totals the information from its
query.

I have a main report containing the 3 subreports where I
display my totals.

This database worked fine in Access 97.

After upgrading to Access 2000, I get error(3211) THE
DATABASE ENGINE COULD NOT LOCK TABLE <mytablename> BECAUSE
IT IS ALREADY IN USE BY ANOTHER PERSON OR PROCESS. This
error occurs when I try to open my main report.

This error pops up twice. I've learned that it is caused
by my 3 queries. If I goto the queries section of access
an try to open my 3 queries manually and all at once, The
first will work fine and the other two cause the error.

Is there another way for me to get my 3 totals from the
dbase table and display them on one main report?

Thanks!