| re: MS Access 2000 - Record data shifting to the right
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
<wesley.d.gibbs@gmail.com> wrote in message
news:1138624928.596617.263470@o13g2000cwo.googlegr oups.com...[color=blue]
>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.
>[/color]
| 
