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-15 : 12:04:01
|
| I have an ACCESS 2007 Database that I transferred to a SQL Server Express Bback end table structure. When this Database was only in ACCESS the primary key was set to AUTO NUMBER. In SQL this table has the same field set a primary key - after i linked the tables, in access this table still has the same field set as a primary key. When I go to create a record, it is not creating the auto number, like it did in ACCESS 2007? This is a problem as this field needs to create at the time the record is created. How do i fix this?WClement |
|
|
|
|
|
SQL_Linked to ACCESS 2007