?
Solved

Autonumber in Access97?

Posted on 1998-08-16
1
Medium Priority
?
221 Views
Last Modified: 2010-03-19
Hi experts,
I am using SQL Server 6.5 sp4 at back end and Access97 in front.  I need to define a field with autonumber for access.  What is the equvaliant in SQL Server.

thanks
0
Comment
Question by:msali
1 Comment
 
LVL 1

Accepted Solution

by:
DennisH earned 80 total points
ID: 1089581
Yes there is an equivalent in SQL-Server 6.5 and later.  In SQL-Server you need to set the IDENTITY property of the field that you want to be an autonumber field.  If you are using Enterprise Manager for SQL Server, you can just set the Identity column in the Table Designer, Advanced Features, Primary Key tab.  You can also set it using a Transact-SQL CREATE TABLE statement.  The field will be of type "INT".
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question