Rows in a Jet Access database disappear

[tmrabet]

Hello,

I have a software that uses a jet access database. In this database
there is a table that contains the name of the customers with their
characteristics. The software does not allow deleting customers except
after entering a password that users do not have. The other way is to
delete it directly from the table, and no one has access to this
database. This is to say that rows are not deleted by accident.
However, some rows often disappear from the table.
Is there a known bug, or do I have a configuration problem that causes
this ?

Thank you for your help.

Tarik

 

[Allen Browne]

Do you have relationships between other tables and customers?

If so, if you double-click the line in the relationships window (Tools |
Relationships), is the Cascading Delete box checked in any of those
relationships?

 

[Jeff Boyce]

Tarik

On what basis have you concluded that rows are disappearing? Does the
number of total records go down? If so, Allen's offered a suggestion re:
Cascading Deletes.

Does the number of total records stay the same? If so, you may not be able
to see the rows where you are use to seeing them, but the rows are still
there.

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Pieter Wijnen]

It might also be a compact/repair problem (network or other)

Pieter

 

[tmrabet]

Thank you all for your prompt responses,

actually, the software returns the number of rows in the database,
which is in my case equivalent to the number of customers. However, the
last number is greater than the total number of customers, which means
that some lines are not counted (I concluded they have been deleted).
I will check this cascading issue and keep you updated.

NB: The number of a new created customer is the last one+1, and the
customers are never deleted from the database.

Thank you again.
Tarik

 

[Jeff Boyce]

We're not there, so we can't tell how you are determining your numbers.

If you are using an Autonumber data type to "count" your rows, you're in for
a (rude) shock -- it won't work (accurately).

If you are using the navigation information, that tells you how many rows.

How are you determining "number of customers"? With a query? If so, post
the SQL.

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Tony Toews]

I have a software that uses a jet access database. In this database
there is a table that contains the name of the customers with their
characteristics. The software does not allow deleting customers except
after entering a password that users do not have. The other way is to
delete it directly from the table, and no one has access to this
database. This is to say that rows are not deleted by accident.
However, some rows often disappear from the table.
Is there a known bug, or do I have a configuration problem that causes
this ?

Are you using Access forms to create new customers? If not ignore
this. If so then folks can start to enter a customer and then change
their mind and back out. This will "consume" that autonumber value
but won't actually write a record.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm