Error Message - Locked table

[Tanya]

Hi I keep getting the following error message after I have closed one form
and go to open another.

"You tried to lock table ".... " while opening it, but the table cannot be
locked because it is currently in use. Wait a moment, and then try the
operation again.

When I wait say 30 seconds befor opening the second form, all is well. But I
don't want the user to have to wait. Is there any way to get around this?

Regards
Tanya

 

[Golfinray]

A little more information please. Is this a database on one computer, split,
networked, how many users, happenning to everyone on the network?

 

[Tanya]

I am still in the development phase therefore it is on my local computer,
however having said that a colleague has placed the db on a network where
only he accesses it and has the same problem.

version is 2003

regards
Tanya

 

[Tanya]

I have been investigating and found that if I change the properties of each
form for Lock records to "No Records" I do not have the problem.

Not sure that this is such a good thing however.

Any thoughts on this matter?

cheers
Tanya