?
Solved

Receive error "Record is deleted" when opening table

Posted on 2011-02-14
14
Medium Priority
?
281 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:avlna
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 7
14 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34887449
i would set the records lock property to Edited record to prevent this thing from happening.
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 34887472
setting the record locks property to Edited records, the record is locked as the user started editing any field in the record and will remain locked until the user close the form or move to another record.
this assures that only one user can edit a record at a time.
0
 

Author Comment

by:avlna
ID: 34887536
Why are there so many # signs in this record?
0
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34887596
if i am not mistaken, those signs of deleted record.
does it go away when you  did a compact and repair?
0
 

Author Comment

by:avlna
ID: 34887630
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?
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34887652
all the fields have the # sign?

backup your db first.

can you delete the record with the # sign?
0
 

Author Comment

by:avlna
ID: 34887706
No, not all the fields have # signs.  It looks like all of the text fields, but not the dates or checkboxes.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34887733
can you select the field, then copy and paste to Notepad?
what does it show in Notepad?
0
 

Author Comment

by:avlna
ID: 34887910
In Notepad it shows all of the # signs plus zeros.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34888098
that record is corrupted..
0
 

Author Comment

by:avlna
ID: 34888366
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.
0
 

Author Comment

by:avlna
ID: 34888719
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?
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34888791
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
0
 

Author Comment

by:avlna
ID: 34888859
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.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question