Posted by Erland Sommarskog on 01/31/08 22:41

(cbrewer2@kc.rr.com) writes:
> I am working with a database that was created in Lotus and importing
> it into Access. There are hundreds of clients in this data base that
> have to be kept and maintained. My question is: Will auto numbering
> work with this imported file and will it continue with the last number
> that is in there and if not can I make it work and how?

Run sp_help on the table, to see if it has any IDENTITY column.

If you are using SQL Server that is. If you are using Access, you should
ask in comp.databases.ms-access.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: sql learning
• Prev in forum: Re: Create Table with Variable included in Table Name
• Thread view: Re: autonumber

[Reply to this message]