A #Deleted Question

[Lunatic]

In a database I built for someone else I've run into a problem. There are 226 rows with data, however just a few minutes ago one of the rows of data suddenly displayed '#Deleted' in every column.

A little more on the database
Has 4 parts, 2 tables, 1 form and 1 subform. The form is has one selection, 'state' where the user selects the state and all the records for that state appear in the sub form. The user then enters the tracking information into the sub form.

Its the table tied to the subform that this happened to and its not for an entire state, just for one record.

3 questions:
1) What could have caused this?
2) Is there anything I can do to prevent this in the future?
3) Is it possible to retrieve the data that was lost?

Help is always appriciated! Thank you!

***************************************
Have a problem with my spelling or grammar? Please refer all complaints to my English teacher:
Ralphy "Me fail English? That's unpossible." Wiggum

 

[Darrylles]

Hi Loon,

Is this app. a shared app. by any chance? i.e. could anyone else have had it open at the time that you saw this?

What you saw was a record being deleted.

Sounds to me like someone deleted this record, as you were looking at it.

ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[Lunatic]

Darrylle

Yes it is shared, but only one was using the system at the time.

Its weird because after I deleted the record that displayed #Deleted all the way across, the entire table stopped responding.

When the #Deleted record was in the table the table could be opened, now I can't even open it.

I'm not worried about the data loss, not much data was entered today and it was on a backed up network drive so we'll retrive the backup copy, but I want to make sure this doesn't happen again.

Someone inside the company suggested the database engine was corrupt but when I went to reinstall it, I was told I had the most recent version.

Finally, it wouldn't have been possible to delete the entire record from the form that was being used because only a fraction of the fields are displayed, at worst the user would only have been able to delete the data in the fields (because they don't use the tables, just the form which opens automatically).

Perplexing :/

***************************************
Have a problem with my spelling or grammar? Please refer all complaints to my English teacher:
Ralphy "Me fail English? That's unpossible." Wiggum

 

[traingamer]

...it wouldn't have been possible to delete the entire record from the form that was being used because only a fraction of the fields are displayed...

If the form is based on a table and you have record selectors on the form, you could delete 'all' fields, not just the ones shown. (I don't know if this is the case or not with your form.)

 

[Lunatic]

No record selectors, I always disable those, but thats good to know. Another reason to always remove them.

Thanks!

***************************************
Have a problem with my spelling or grammar? Please refer all complaints to my English teacher:
Ralphy "Me fail English? That's unpossible." Wiggum

 

[PHV]

Deleting only some fields from a record is a non sense in ANY RDBMS !

 

[Lunatic]

RDBMS? DBMS = Database Management System I'm guessing, but the 'R'?

It was not intended the user would delete anything from the database, instead it was designed for them to add additional information, and as such they only had access to the few fields they needed.

***************************************
Have a problem with my spelling or grammar? Please refer all complaints to my English teacher:
Ralphy "Me fail English? That's unpossible." Wiggum

 

[Darrylles]

Hi,

There are 226 rows with data, however just a few minutes ago one of the rows of data suddenly displayed '#Deleted' in every column.

A row is a record in a table, therefore a record was deleted.

You were in design mode, looking at a table that someone else was using via a form in the same application, and that user deleted a record intentionally.

You then attempted to delete a record (in table view mode) that Access told you was already deleted. Why do this? You should simply close the table and re-open it, to refresh it's view.

When you ensure that no one has the application (or database open) - does a *.ldb file still exist in the database folder? i.e. if your database is called FRED.mdb, then does FRED.ldb exist when you are sure that no one else has opened it? If so - delete the *.ldb file.

Try and open it again.

Otherwise, you have corrupted the database, and you need to revert to a network backup.

ATB

Darrylle






Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[Darrylles]

Hi,

R = 'Relational'


Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[Lunatic]

Darrylle

Rational - thats makes sense ;p

I had opened and closed the database several times after I had everyone who was in it exit. There was not .ldb file (checked) and I was not using the table as the same time as anyone was using the form.

The #Deleted record was still there and evertime the main form or sub form opened up there was a 'Record Deleted' message that popped up and the sub-form was blank.

So it looks like it was a corrupted database and I'm not going to find out why

Thanks for all your help everyone!

***************************************
Have a problem with my spelling or grammar? Please refer all complaints to my English teacher:
Ralphy "Me fail English? That's unpossible." Wiggum

 

[Darrylles]

Lunatic,

(RELATIONAL not RATIONAL.)

1) Open up the database in design mode.
2) Open the table that the deleted record is apparently in.
3) Is this showing #deleted anywhere?

atb

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[Lunatic]

Reading... problem....

Table opens fine in the design view, the columns are all fine, it was a single record, not a column that showed #Deleted in every column.

So while the table opens in design view it does not open in datasheet view. It used to but stopped once I tried to delete the row with #Deleted in every field.

***************************************
Have a problem with my spelling or grammar? Please refer all complaints to my English teacher:
Ralphy "Me fail English? That's unpossible." Wiggum

 

[PHV]

If you're the only one using the DB when you get a whole row of #Deleted in a table you've open in datasheet view, then you have a corrupted table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Darrylles]

Lunatic,

A column is a field within a record (a row).

You had '#deleted' in every field (column) in one record (row) - seen as "#deleted" horizontally across all columns.

It seems that you can't open the table to view data.

1) What could have caused this?
2) Is there anything I can do to prevent this in the future?
3) Is it possible to retrieve the data that was lost?

1) Read my posts above.
2) Don't do this again.
3) Refer to your backup system.

You must supply more information about your database tables etc. before possible data retrieval can be decided upon.

ATB

Darrylle








Never argue with an idiot, he'll bring you down to his level - then beat you with experience.