I have been trying to use the DTS Import to upsize an Access 97 DB to SQL
7.0 but I have not been able to determine whether, or how, SQL 7.0 imports
Access "autonumber" fields. All of my tables use autonumber fields to
maintain relationships so I must be able to import them and have SQL 7.0
make them identity fields, seeded with the values that are already in the
Can anyone tell me if SQL 7.0 will recognize this and create the table in
the SQL DB properly so that all of my relationships integrity is not lost?
Does SQL 7.0 recognize Access autonumber fields?
If it recognizes autonumber fields, will it create them as identity fields
when it imports into SQL 7.0?
Will it seed them properly so that my current data and relationships are not
lost and it continues to increment the field correctly when records are
Do I need to do anything to make sure this happens?
Do I need to manually set up a trigger for each table to do this?
The documentation has not been helpful in this area.
Senior Network Engineer
Windows NT Administrator
Aspiring AS400 Administrator
ASP and Web Developer
More to come...
Don't make me use uppercase...
Calm down -- it's only ones and zeroes.