Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Why won't Access assign a Primary Key ID to my linked SQL Table?
34 views
Skip to first unread message
dkimbrell
Mar 9, 2012, 10:07:35 AM3/9/12
to
In Access (2008), when I have a local table with a Primary Key and I
add a new record in the table view, Access automatically gives the new
record a primary key value.
But when I open a table linked to my backend SQL Server that also has
a primary key (identified in SQL Server), Access will not give it an
ID and so I cannot add a record there.
How do I fix this?
add a new record in the table view, Access automatically gives the new
record a primary key value.
But when I open a table linked to my backend SQL Server that also has
a primary key (identified in SQL Server), Access will not give it an
ID and so I cannot add a record there.
How do I fix this?
dkimbrell
Mar 9, 2012, 10:17:57 AM3/9/12
to
I should also specify, that when I try to add records to a local
Access table, the Primary Key is set to Autonumber. I don't see that
as an option in SQL Server. I'm sure that's the reason, but how do I
work around that so that I can add records in a table view in Access?
Access table, the Primary Key is set to Autonumber. I don't see that
as an option in SQL Server. I'm sure that's the reason, but how do I
work around that so that I can add records in a table view in Access?
Dan Dungan
Apr 4, 2012, 6:41:55 PM4/4/12
to
Is there something that stops you from using the primary key assigned
by SQL server?
by SQL server?
0 new messages