I have an Access db that has a linked table to a sql table. What parameters do I have to set in the SQL table to have it act like a Autonumber field so when I create a new record in access, it makes a new autonumbered record in SQL?
View 3 RepliesI have a newbie question here. I have a SQL Server Database and I need to create a column that displays the row number. I tried adding an Identity Primary Key which worked until a row got deleted and the count was off. How do I create a column that displays the row number and recounts when a row is deleted. Thanks!
View 1 Replies View Related