General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2008 Server
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only