Link to home
Start Free TrialLog in
Avatar of avlna
avlna

asked on

Receive error "Record is deleted" when opening table

I have been asked to look at an Access 2003 database I did not create.  The problem is an error, "Record is deleted",  appears when I try to open the table.  This is a recurring problem with a database that about 30 people use at the same time.  It also has about 180 fields in this table.

After researching I have found that this can happen when two people have the same record open and one changes or deletes the record then closes the database before the other.  The fix is to Compact and Repair, which I have done.  I can then open the table.  Tthe first record has multiple # signs in many, but not all, of the fields.  I checked and the Edited Records property is set to No Locks.  Would changing this property to Edited Record fix the problem or could there be something else that is wrong and needs to be done?  Your help is greatly apprecaited.
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

i would set the records lock property to Edited record to prevent this thing from happening.
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of avlna
avlna

ASKER

Why are there so many # signs in this record?
if i am not mistaken, those signs of deleted record.
does it go away when you  did a compact and repair?
Avatar of avlna

ASKER

No, they are still there.  Prior to the compact and repair I couldn't open the table.  After I repaired it then I could open it and I saw the first record with the # signs.

There also isn't a key field in this table.  Would it help to add an AutoNumber field?
all the fields have the # sign?

backup your db first.

can you delete the record with the # sign?
Avatar of avlna

ASKER

No, not all the fields have # signs.  It looks like all of the text fields, but not the dates or checkboxes.
can you select the field, then copy and paste to Notepad?
what does it show in Notepad?
Avatar of avlna

ASKER

In Notepad it shows all of the # signs plus zeros.
that record is corrupted..
Avatar of avlna

ASKER

I've changed the Form's Record Locks property to Edited Record and added a Autonumber Primary Key to the table.  I deleted the record and now that the records are locked I hope no one will be able to create this record with nothing but # signs.

 I'm going to have the users start to get in a few at a time.  There are 44 of them.  Hopefully, this will work.
Avatar of avlna

ASKER

Well, that didn't work.  Now only one person can open it and the rest of them receive the following:

"The database has been placed in a state by user 'Admin' on machine (user's PC name) that prevents it from being opened or locked".  Am going to cahnge the Record Locks back to No Locks.  Any ideas?
you may need to split your application into backend and frontend

see how and why from this link

Split your Access database into data and application
http://allenbrowne.com/ser-01.html
Avatar of avlna

ASKER

It turns out it did work fine for some but probably after the Admin user logged out.  Can this have anything to do with individual rights?  Why is it doing this?

I split all of my databases but this was created by someone else.  I'm going to discuss this with him first so I don't step on any toes.