I want to upsize my Access databases to MSDE but don't know how to use a Primary Key. When I use the uniqueidentifier I get an unique numer that consists of 16 characters. Is there an option in MSDE to make a primary key equal to Access?! So just with AutoIncrement numbers?

<hr><b>DMXZone support manager</b><br><a href="www.kousman.nl">Kousman web resellers</a>

Hi Rene

The PK in SQL is called and Identity Seed, which can be set to start at any number, also you can set the number the PK increments by. The datatype needs to be set to INT and NOT NULL.

I've not used MSDE or the upsizing wizard, is there an option in there to allow IDENTITY INSERT? I'll have a read up and post back if I find anything.

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>

Hi Rene

Read this:
techrepublic.com.com/5102-22-5059624.html

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>