Importing from Access

[Blorf]

Hi. Have an access database that has grown beyond all plans, and want to migrate the data to sql, and keep access as a front end.

All is well, but when I import my tables, it does not keep the indexes or primary keys. The fields come, and the data comes, but the keys are dropped.

Why? How to fix?

I can modify the tables after import, and will begin doing so after lunch, but wondered if there is an easier way.

Using sql 7.

Thanks,
ChaZ

 

[dbomrrsm]

it wont import the indexes but if the primary key is a physical field in the access table then that should be brought through.

what do you mean by

but the keys are dropped

[blue]DBomrrsm[/blue]

 

[Blorf]

The primary key, say a field calld PartID, comes through as a field, but not as the primary key.

Ok, so I do have to modify the tables after import I am gathering.

What about relationships? Same thing I am guessing.

Thanks,
ChaZ