Hi all

My Access Application uses a MS SQL 2000 Server as back-End DB.
Question:

Is it possible through VBA Code to set following attributes within the MS
SQL Server DB:
- Pimary Key
- Identity
- Identity Seed
- Identity Increment

If so, could you please give me an example of Code how to do this.

Purpose: with the many tables in the DB it is not that comfortable to set
those settings always manually, as soon as I have to create a new DB.

Thanks for the help.

Cheers
Marcel