Hi All,
How can I link a view into MS Access from MS Sql Server, that I can update as a tabble.
Thanks
LaszloInclude the columns from a defined UNIQUE INDEX on the table in your view.
-PatP|||And the table in SQL Server MUST have a primary key defined on it, or Access will not allow you to update it.|||But, the tables have primary keys, the relationships are correct, and the view is updateable on the server, but when I link it into Access then its not work anymore. Even single linked tables (including primary key) are updateable in Access just the views not work.
I found that the one solution is making query form the linked tables in Access.
Showing posts with label msaccess. Show all posts
Showing posts with label msaccess. Show all posts
Subscribe to:
Posts (Atom)