Loosing information

[danny123]

Hi there..

We have Access 2000 database. Everythign is working fine but suddenly it have started loosing information. I entered one record last week and its not showing up now.
I am not a remote user. I entered the data from local machine.
Do someone have any idea about this issue.

Thanks
Danny

 

[llkhoutx]

I've never heard of Access data "loosing information;" I've been an Access user for more than 20 years.

 

[danny123]

Neither do i....but its happeneing..
I have entered data myself last week....and now there is no record for that information in database.
I found some other links also on google where people are mentioned the same problem.
ONe thing may be i need to install the latest service pack.Can someone tell me what is the lastest service pack for access 2000. and what else i need to install in order if i am applying the lastest service pack.
And all the precautions before applying the service pack

Thanks
Danny

 

[CraigDolphin]

I had a similar situation where the db was stored on a server with capacity limits for users. Since I was the author of the db the db file size counted against my sapce allocation even if other users were inputting the data that caused the db to grow over time. When my space allocation limit was reached, the db began to mysteriously 'lose' data without error messages or any other indication that there was a problem.

Not saying that this is the case for you, but if you have space restrictions then this might be something to consider.

 

[The_Doc_Man]

The trick is to be sure that you are properly sharing the database AND don't have the "special alarm" messages disabled that would tell you of conflicts with other users.

If you are doing this from a form, you also want to (PERHAPS) run some event code under the Form_AfterUpdate to verify that a separate DLookup can find the record you just entered.

Once you enter it and verify it, if you THEN lose it, you have to consider that one of your other users is hosing you by deleting something that s/he has no right to touch.

 

[Dennisk]

If the rows are indexed and the index is corrupted then that also may be causing the problem. run the repair utility or better still create a new blank db and import the tables then check the indexes as Access indexed everything under the sun by default.