By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,365 Members | 3,095 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,365 IT Pros & Developers. It's quick & easy.

Auto-increment fields when moving a base from Access to SQL server

P: n/a
Hello all,

I'm a total newbie with SQL Server 2000 and I have a little problem when
moving a database form Access 2000 to SQL Server 2000.
In the Access database, each table has an auto-increment field.
After importing the tables in SQL Server, all the auto-increment fields
are turned into "int" type fields.
Does anybody have an explanation for that mystery?

Thanks in advance,
Yan
Jul 20 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
CJ
You might want to change the field type from int to identity. The identity
field type in SQL Server is analogous to the Autonumber field type in
Access.

good luck

CJ
"Yan Roosens" <ya*********@skynet.be> wrote in message
news:3F***************@skynet.be...
Hello all,

I'm a total newbie with SQL Server 2000 and I have a little problem when
moving a database form Access 2000 to SQL Server 2000.
In the Access database, each table has an auto-increment field.
After importing the tables in SQL Server, all the auto-increment fields
are turned into "int" type fields.
Does anybody have an explanation for that mystery?

Thanks in advance,
Yan

Jul 20 '05 #2

P: n/a
Hi CJ,
You might want to change the field type from int to identity. The identity
field type in SQL Server is analogous to the Autonumber field type in
Access.


Thank you, the error message related to that problem is no longer displayed, I
will now care about the next one :-(

Yan

Jul 20 '05 #3

P: n/a
On Thu, 02 Oct 2003 17:20:57 +0200, Yan Roosens
<ya*********@skynet.be> wrote:
Hello all,

I'm a total newbie with SQL Server 2000 and I have a little problem when
moving a database form Access 2000 to SQL Server 2000.
In the Access database, each table has an auto-increment field.
After importing the tables in SQL Server, all the auto-increment fields
are turned into "int" type fields.
Does anybody have an explanation for that mystery?

Thanks in advance,
Yan

Because that isn't a data type. Look up identity for an explanation of
how sql server can provide that sort of functionality.
Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.