Database engine could not lock table HELP

[TheNoocH]

I'm getting the following error:

The database engine could not lock table 'tblTemp' because it is already in use by another program or process.


the table tblTemp is created with a make table query and added via an append query...i copied the queries that created this and modified them to create a separately new table but now when i go back to run the originals i get the error above....any help would be great

 

[Norie]

When are you getting the error?

Are you using any code?

Has Access shutdown unusually at any point?

Have you tried Tools>Compact and Repair...

 

[TheNoocH]

i was getting the error trying to run a command button with vba behind it that ran a make table and append table query ...then a report off that info...
I did tyr compact and repair....

opppsss....just found it....on my form i must have hit control source by mistake while changing properties and it's referencing a query it shouldn't...

thanks for you help anyway...