data replaced with ###

[Burt]

I have a user who has a 4 table relational database. This morning when they
opened the db one records data had changed to all ####'s

no one else had been using the db.

open opening the table, there were error messages relating to code 1206 and
1053.

Any ideas what could have caused this problem?

 

[Arvin Meyer [MVP]]

It is most likely a corrupted record. Try these in order.

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Try doing a Compact and Repair on the copy of the back-end database.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some other suggestions. Unfortunately, some corruption cannot be fixed -
you may need to create a new database, import what can be salvaged, and
recreate the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[Rick A.B.]

I have a user who has a 4 table relational database. This morning when they
opened the db one records data had changed to all ####'s

no one else had been using the db.

open opening the table, there were error messages relating to code 1206 and
1053.

Any ideas what could have caused this problem?

One posibility is that the data is not corrupt it just too large to
fit in the form's text box. I've seen this happen often with dates.
If this is the problem all you need to do is enlarge the text box to
accomidate the data. If not, Arvin's post is your best bet.

Rick

 

[Arvin Meyer [MVP]]

One posibility is that the data is not corrupt it just too large to
fit in the form's text box. I've seen this happen often with dates.
If this is the problem all you need to do is enlarge the text box to
accomidate the data. If not, Arvin's post is your best bet.

That would be true only for numeric textboxes. (Yes Dates are really
numeric, they are specially defined Doubles) Even then, it is unlikely that
all of them would be too narrow.

 

[Burt]

Thanks for the info. The data was definately not too big for the columns. I
guess it somehow got corrupt.....