Solved the data base engine could not lock table

[Tom d]

trying to split a database get this error message the data base engine could not lock table 'tlbblood pressures' because it is already in use.
I am using a stand alone computer. nothing is open in access

 

[pbaldy]

Is there perhaps a recordset that gets opened on startup and is still open? Try opening the db while holding down the Shift key and then trying to split.

 

[Tom d]

Is there perhaps a recordset that gets opened on startup and is still open? Try opening the db while holding down the Shift key and then trying to split.

Thanks but did not work

 

[pbaldy]

Hmm, and no form/table/query is open? Sorry, but I'm stumped.

 

[Tom d]

Is there perhaps a recordset that gets opened on startup and is still open? Try opening the db while holding down the Shift key and then trying to split.

Thanks but did not work

 

[Gasman]

Compact,zip and upload your db.
Responding to the same post twice, does nothing to help.

 

[Tom d]

Compact,zip and upload your db.
Responding to the same post twice, does nothing to help.

 

[Tom d]

tried it again, hold down the shift key and it worked
ot work

 

[Gasman]

Split for me , no problem?

 

[Tom d]

tried it again, hold down the shift key and it worked
ot work

tried it again and it did not work

 

[Tom d]

tried it again and it did not work

Changed my keyboard and it works

 

[Gasman]

Changed my keyboard and it works

I just used my mouse?

 

[CJ_London]

1 Try creating a new db then import the tables. Make this you BE
2. In a copy of your original db delete all the tables then use the external data tab to link to your new BE