Auto number in a Access 97 or 2000 linked to a SQL 2000 Server DB 1

[JBuyna]

I have recently converted my Access 97 /2000 database to SQL 2000 server. I was relying on the Autonumber feature in the software, but now I am unable to use that field type with SQL 2000 Server.

I need a way to do a ticket number system for my helpdesk software with SQL 2000 server.

Any Ideas ?

 

[camelman]

In SQL make the field that was your autonumber an INT (integer)
In the fields properties make Identity = yes, Identity seed = 1, Identity Increment = 1.

This will give you a field that works exactly like an autonumber.
The other bonus here is that you don't have to get rid of your existing data in the field like you would if you were trying to convert an Access Int to an Access Autonumber.

Hope this helps

 

[Guest_imported]

Thanks for that Tip, It helped me get over a day long headache. You are the Master!