Tables

[Guest_imported]

I have built a database + a program in Access.
In the process of building it, I have used lot's of dummy data in order to test my program.

In my tables I have otfen used automatic running numbers as primary keys.
Now that I wish to start actually working with the prog
I need to first erase part of the date in the tables.
however I want my automatic running numbers to be calibrated (So I will not have a record starting from 80)

How can I do it without breaking the relations between tables as Access demands?

 

[ToeShot]

When I run test apps like that and I finish them what I do is create a new database then import everything from the DB I just finished. I import the tables without the data just the definition and the relationships. This gives me a fres database starting any autonumbering from 1

HTH Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait

 

[Guest_imported]

that's a good idea.
Never really thought about it !

thanks