By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,333 Members | 1,962 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,333 IT Pros & Developers. It's quick & easy.

linked table from SQL - can not be updated

P: 10
I have a linked table from SQL server and created a local copy. user may edit the values in the local table and when it is finalize, sql will be updated. i created an update query that will do the work but there's an error. it seems that the linked table is not updateable. is it because of sql permissions on the table? if so...is there a work around using MS Access?

in sql, the table can be updated. it is only when i linked it to access that i cant update the table.

thanks!
Dec 27 '06 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,494
If this turns out to be a SQL Server permission issue then you will need to speak to your SQL Server administrator. This is a specialist issue that is not straightforward and depends on many option settings and how your particular server has been configured.
You could try in the SQL forum but don't expect anything from anyone unless you put in a lot more relevant information.
I still think your local SQL Server administrator is the most appropriate place to look.
Dec 30 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.