Access 2000

S

sford

My database is starting to erase records. 1. What is causing this? 2. How
can I fix it? 3. How can I prevent this from happening in the future?

There is about over 2000 records in the database and records are just
dropping like there is no tomorrow. HELP!

Thank you.
 
D

Dirk Goldgar

sford said:
My database is starting to erase records. 1. What is causing this?
2. How can I fix it? 3. How can I prevent this from happening in the
future?

There is about over 2000 records in the database and records are just
dropping like there is no tomorrow. HELP!
Click to expand...

I've never heard of a database just "erasing records" before, if by that
you mean the records just disappear as if deleted. There are forms of
corruption that lead to records coming up with #DELETED in all fields.
What exactly is happening in your case? Where are you looking for the
records -- in a table datasheet? in a query datasheet? on a form?

Since we don't know exactly what's happening, before you do anything
else make a new backup copy of the database file and set it aside. Do
this when the database is closed.
 
S

sford

The records seem to be disappearing. I will look up the record in form
view(Where the data entry is done) and it will not show up. I will then look
in the table datasheet and the record is not there. Yes they disappear as if
it were deleted. How can I find the corruptions? Ah, this is so confusing.
I didn't create this database, it was done in 2001 and the creater no longer
works here.
 
D

Dirk Goldgar

sford said:
The records seem to be disappearing. I will look up the record in
form view(Where the data entry is done) and it will not show up. I
will then look in the table datasheet and the record is not there.
Yes they disappear as if it were deleted. How can I find the
corruptions? Ah, this is so confusing. I didn't create this
database, it was done in 2001 and the creater no longer works here.
Click to expand...

Hmm. Here are some questions. I don't know how conversant you are with
Access, so some of them may seem like dumb questions.

+ Are you sure the records aren't actually being deleted by a user?
I've known people to delete records from a query, not realizing that
doing so deletes them from the table. Or to make a copy of a form, then
delete records from that copy, thinking it's a completely different set
of records from the records shown on the original form.

+ Are you the only user of this database?

+ Is it possible that the records are still there, but being hidden by a
filter that has been applied? When you look at the form or the table
datasheet, is the Filter button on the toolbar "pushed in"?

+ Are you looking at a form or datasheet that is based on a query
(whether a stored query or a SQL statement)? If so, does that query
have a WHERE clause that might exclude some records.
 
Top