Not accepting new records..?

  • Thread starter Thread starter Kent Johnson
  • Start date Start date
K

Kent Johnson

Hi all,

I have two Access table with primary key defined on both tables.
When I join them together I can add new records.

But If I then export the tables to SQL-server and link them back to Access
then I cannot add new records. I have also added primary key on the
SQL-server tables.

How can I get SQL-server tables to accept new records?

/Kent J.
 
When did you add the primary key, before or after linking? If you view the
design view of the SQL table, do you notice a primary key? You may need to
relink the table.
 
I figured it out by myself.
You need to include primary key from both tables in the query.
I don't understand why but it works.

/Kent J.
 
Back
Top