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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment