JumpinJimRivers
MIS
Hello everybody,
It was just discovered that in my client's Access database there are two tables in each user's front-end that are NOT linked to the back-end like they ought to be, so each user's data for these two tables are being stored locally. This is an accident, and I need to somehow consolidate all this data back into the back-end. The problem is that the primary keys are autonumbers and the secondary key in the related table is an autonumber, so I cannot do a simple import since I am dealing with multiple tables, which means that I am dealing with duplicate autonumbers. Is there a "clean" way of handling this or am I basically screwed here?
Any help is appreciated. Thanks.
It was just discovered that in my client's Access database there are two tables in each user's front-end that are NOT linked to the back-end like they ought to be, so each user's data for these two tables are being stored locally. This is an accident, and I need to somehow consolidate all this data back into the back-end. The problem is that the primary keys are autonumbers and the secondary key in the related table is an autonumber, so I cannot do a simple import since I am dealing with multiple tables, which means that I am dealing with duplicate autonumbers. Is there a "clean" way of handling this or am I basically screwed here?
Any help is appreciated. Thanks.