Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Updating a linked SQL table

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-09-01 : 18:17:02
Juan writes "Dear SQLTeam,

I currently link to a SQL database via the MS Access interface. Normally I do not have any problems updating any of the fields in the tables using Access, but this one table does not allow me to add or edit fields. I have double checked the permissions of the table in SQL several times and they are the same as the other editable tables. I have full administrative Access to SQL but I haven't been able to figure out why I cannot edit this one table.

Please demonstrate your vast knowledge by answering my question.

Thank you.

Juan

SQL Server 7.0
Windows NT 4.0 Server SP6"

   

- Advertisement -