Auto-inc keys are hell whenever you want to switch backends. My best practice is to separate moving data and running the app: import done without activated auto-inc or with an additional surrogate key.

>i have a dbc and want to export a few tables into sqlserver express with the data attached.
>in vfp the PK was handled by an insert trigger in SQL i want to use the auto-incrementing feature
>can that be done and if yes HOW?
>
>Next I need to create an access front end. possible??
>
>thanks
>
>Peter