MS Access 2000 - Record data shifting to the right

[wesley.d.gibbs]

I have a MS Access 2000 problem. My access database has quite a few
tables (about 10)
but my problem is only w/1 table and this 1 table has a 1 to 1
relationship w/1 other
table.

Every once in a while (I'd say about once a month) the data for 1
record gets shifted to
the right in this one table. To give you idea of what is happening,
see the following:
What record should look like:

ID DOCKET Number AnimalType Sex Age
1 111111 Giraffe Male 22

What record looks like:

ID DOCKET Number AnimalType Sex Age
1 111 111Gira ffeM ale
Every time that this error occurrs in this table the table that it has
a 1 to 1
relation with also has the "Docket Number" completely missing.

[Jeff]

I have had this and am not sure why it happens, but it is a corruption.

To fix it I have at times succeeded with a compact and repair. Other times I
have had to rebuild the file or revert to a version prior to the problem,
update changes and import to current data.

Wish I could help further but I suggest treating this as a database
corruption and immediately take steps to restore the file to an uncorrupted
state.

Jeff

<we************@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

I have a MS Access 2000 problem. My access database has quite a few
tables (about 10)
but my problem is only w/1 table and this 1 table has a 1 to 1
relationship w/1 other
table.

Every once in a while (I'd say about once a month) the data for 1
record gets shifted to
the right in this one table. To give you idea of what is happening,
see the following:
What record should look like:

ID DOCKET Number AnimalType Sex Age
1 111111 Giraffe Male 22

What record looks like:

ID DOCKET Number AnimalType Sex Age
1 111 111Gira ffeM ale
Every time that this error occurrs in this table the table that it has
a 1 to 1
relation with also has the "Docket Number" completely missing.