T
TimJ
I am running access 2003. I have a split database and I am using multiple
data files (back ends). I have recently found that some of my tables have
become corrupted in all of the data files. I believe the cause was the
recent conversion of the primary keys of these tables. We decided to change
the data type from auto number to double so we could included a unique data
file identifier so we could latter aggregate the data from all back ends and
tell which data they came from which backend. Any way, the first alarm was
that the combo boxes on our forms that allow to select a record to go to
started either not working at all or giving undesired results.
I have since posted and learned how to fix the tables by importing all the
working tables into a new db (excluding the corrupted tables) and
programmatically moving the corrupted data into the new db. That worked
great! All the combo boxes started working again. Now the code that I was
given from the post for moving the corrupted data transfers the data but no
relationships or even primary keys. Once I try to apply the primary key, the
combos start acting up again. I guess applying the primary key is corrupting
or recorruping the tables some how.
Any ideas what my problem is or how to fix it?
I am also experiencing another phenomenon which may or may not be related.
I am sporadically seeing Chinese characters on reports. I don’t think this
is related to data corruption because it is happening on tables that were not
part of the primary key conversion as with the others. But then again that
may not be the cause of my corruption at all.
Please help, lots of data is being entered into these databases daily. I
wish this wasn’t the case but it is out of my control.
Thank you,
Tim J
data files (back ends). I have recently found that some of my tables have
become corrupted in all of the data files. I believe the cause was the
recent conversion of the primary keys of these tables. We decided to change
the data type from auto number to double so we could included a unique data
file identifier so we could latter aggregate the data from all back ends and
tell which data they came from which backend. Any way, the first alarm was
that the combo boxes on our forms that allow to select a record to go to
started either not working at all or giving undesired results.
I have since posted and learned how to fix the tables by importing all the
working tables into a new db (excluding the corrupted tables) and
programmatically moving the corrupted data into the new db. That worked
great! All the combo boxes started working again. Now the code that I was
given from the post for moving the corrupted data transfers the data but no
relationships or even primary keys. Once I try to apply the primary key, the
combos start acting up again. I guess applying the primary key is corrupting
or recorruping the tables some how.
Any ideas what my problem is or how to fix it?
I am also experiencing another phenomenon which may or may not be related.
I am sporadically seeing Chinese characters on reports. I don’t think this
is related to data corruption because it is happening on tables that were not
part of the primary key conversion as with the others. But then again that
may not be the cause of my corruption at all.
Please help, lots of data is being entered into these databases daily. I
wish this wasn’t the case but it is out of my control.
Thank you,
Tim J