Record / Table Supposedly Locked

[Ally72]

A database that was fine last week now has been throwing up all sorts of problems. One of them in when going to enter into the form (it doesn't matter what field it is) an error message comes up:

Field can't be updated

When you click Help it says:

The field can't be updated because another user or process has locked the corresponding record or table. (Error 3164)

There is no-one else using it and even when I transfer it onto my local PC it does the same thing.

Am using Acc '97: have compacted, repaired, compiled and saved all modules and tried importing it all into new db and none of it works.

I cannot understand why it's doing it. Can anyone help please?

 

[smedvid]

I've seen some strange things myself.. I would suggest the following:

1. Attempt to restore a backup of the database from a time period well before the problem surfaced. Hopefully, you have a good backup strategy on the network as well as keeping a development copy that reflects that latest code version.

2. Next, check out the backup. Does it perform the same?

3. Import the data from the current version into the Backup version. Test... ?

4. Did any rules change on the database? Constraints, indexes, etc.

5. Is anyone attached to the database? Can you open it exclusively? Did anyone change anything? Check date stamp on objects in database.

6. If all else fails, attempt to recreate the form object from scratch.

htwh Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[Ally72]

Thanks - I will try these.