Note: Also posted in comp.databases.ms-access
Greetings everyone!
When I set up SQL Server Express in the past and used connection strings in Access (using TempVars) to connect to the tables, I had no trouble running UPDATE queries in Access to change the contents of the tables on the back end. Now I'm working on a project that has a SQL Server backend (not Express) that was set up by the customer, who has much experience setting up SQL Server instances. When I try to run the UPDATE query like before, I get the error message "Operation must use an updateable query." I've tried the following things:
1) Gave the role assigned to the user db_datareader and db_datawriter rights
2) Assigned the table in question as a Securable with Update, Select, and Insert rights
3) Used the owner login and password in the connection string
In all cases, I'm able to run Select queries on the tables. I don't want to use ODBC connections. Is what I'm trying to do possible with a SQL Server backend? The SQL Server admin said it was an Access issue, not a SQL Server issue.
James A. Fortune