Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wclement
Starting Member
2 Posts |
 Posted - 2011-08-19 : 11:19:38
|
| In SQL my primary key field is an INT and Identity is set to yes (1,1). I have linked this to an ACCESS 2007 Front End User database. Tables are linked - primary key is selected in ACCESS for the same field. When we enter a record ACCESS is not creating an auto generated number in the primary key field? I do not know how to fix this. I am on a deadline to get this up and running and I am STUCK. Any help would be much appreciated.WClement |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-08-19 : 12:12:20
|
| Access won't create a number, SQL will when the row is inserted.It's different from an access autonumber in that access creates the number when you start on the row, SQL will only create it when you're finished with the row.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
SQL Primary Key Identity is set - Not creating