Denthion
asked on
Access 97 Back end Update
Good Morning All,
I have recently finished updating the front end of my companies database. To bring things in line with what they wanted I have had to add fields to some of the back end tables. Now I find my self almost ready to go live and stuck on how to move the current data in to the new tables. I have tried using different query but I'm new at Access 97 so I'm sure i'm missing something. i'm getting key violations on the append query which looks like the one I should use. please help.
Thank you for your time
DWG
I have recently finished updating the front end of my companies database. To bring things in line with what they wanted I have had to add fields to some of the back end tables. Now I find my self almost ready to go live and stuck on how to move the current data in to the new tables. I have tried using different query but I'm new at Access 97 so I'm sure i'm missing something. i'm getting key violations on the append query which looks like the one I should use. please help.
Thank you for your time
DWG
Don't know whether the backend has any relationships defined, but if it does, then you must load the tables in the proper order. Those tables on the one side of one-to-many relationships must all be loaded first, otherwise, you will get those foreign key errors.
New at Access 97??? That version is almost 20 years out of date. I suggest upgrading to Access 2010. Much work will need to be done to upgrade code, but it should be done now, as you may not even be able to open Access 97 databases in current Access versions before long.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, This is the kind of information i was looking for.