--Cross-post from SQL Server forum--
I've got an application that I'm trying to migrate out of Access97.
I'm starting with moving the data into a SQL Server 7 database. I should, theorectically, still be able to use the Access front-end until it can be replaced later.
I have transferred the data and linked the SQL tables to the Access database using the SQL database owner login/password.
In SQL Server, I have gone into properties/permissions for the tables and checked all the permissions for the database owner user account.
I am able to open the tables and look at the data (I could do this before changing permissions), but when I try to modify or add records, I get an error telling me the update failed.
ODBC--update on a linked table 'dbo_orders' failed.
I know this is vague, but I'm pretty new to SQL Server. Is there something obvious that needs to be set in SQL Server to allow the updates? Something begginers miss???
My SQL tables have PK's, so that's not it.
I should probably also mention I have a diagram created for the SQL database linking the FK's and PK's of the tables to each other.
Initially, I'm just trying to edit data in one field of a table. This field is not part of any reference and has no constraints, triggers, etc. _________
Rott Paws
...It's not a bug. It's an undocumented feature!!!
I've got an application that I'm trying to migrate out of Access97.
I'm starting with moving the data into a SQL Server 7 database. I should, theorectically, still be able to use the Access front-end until it can be replaced later.
I have transferred the data and linked the SQL tables to the Access database using the SQL database owner login/password.
In SQL Server, I have gone into properties/permissions for the tables and checked all the permissions for the database owner user account.
I am able to open the tables and look at the data (I could do this before changing permissions), but when I try to modify or add records, I get an error telling me the update failed.
ODBC--update on a linked table 'dbo_orders' failed.
I know this is vague, but I'm pretty new to SQL Server. Is there something obvious that needs to be set in SQL Server to allow the updates? Something begginers miss???
My SQL tables have PK's, so that's not it.
I should probably also mention I have a diagram created for the SQL database linking the FK's and PK's of the tables to each other.
Initially, I'm just trying to edit data in one field of a table. This field is not part of any reference and has no constraints, triggers, etc. _________
Rott Paws
...It's not a bug. It's an undocumented feature!!!