Adding Records in Access to a Linked Table on SQL Server

S

schaapiee

I stole a post from a year ago..see below
How can you get around the below problem? I have tables and views
linked to SQL server, and when I use the Linked Table Manager to
refresh all the links, I can no longer add new records. If I go in an
create new links to these references, those rights are restored. Is
there maybe an interface I can create, or code I can use that replaces
the Linked Table Manager that keeps the unique identifier intact when
refreshing the links? Thanks for any help.

Old post said:
"I had been identifying the unique fields whenever I linked the tables
to the
Access FE; however, what I didn't know was that when you use the Linked
table
manager and refresh your links (Not an uncommon operation), this
information
as to Unique fields is apparently wiped out and the Linked Table
Manager DOES
NOT help you out by asking for them again. "
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

access 2007 FE/BE linked table problem 2
Linked Table Manager in ACCESS 4
Linked SQL Tables don't report Cascading Updates and Deletes 2
Linked Table Manager Errors 12
Problem with Linked Table Manager 1
Access 2007 - Copy linked table to a local table or have linked tableas read-only 0
Linked Table Cant Delete Record 2
sql server linked table not accurate 7

Top