Recordset is Not Updateable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've gone from an Access to an Access/SQL Server solution. The query is a 4 table join. The tables in SQL Server all have defined PK. Table B,C,D are linked to A.

tableA 1 - 1 table
- 1 table
- m table

When the app was in Access, this query was updateable. Now with a SQL Server 2000 backend, the recordset is not updateable. When the query is updated to contain only two tables, the recordset is updateable. As soon as a third table is added, the recordset in not updateable
 
Relink the tables in Access, making sure that when it
prompts you for the unique identifiers for each table, you
select those fields.

-----Original Message-----
I've gone from an Access to an Access/SQL Server
Click to expand...
solution. The query is a 4 table join. The tables in SQL
Server all have defined PK. Table B,C,D are linked to
A.
tableA 1 - 1 tableB
- 1 tableC
- m tableD

When the app was in Access, this query was updateable.
Click to expand...
Now with a SQL Server 2000 backend, the recordset is not
updateable. When the query is updated to contain only two
tables, the recordset is updateable. As soon as a third
table is added, the recordset in not updateable.
 
Can you drop the links and re-link? I think refreshing
alone doesn't prompt for record identifiers.

Don't really know for SQL Server, but that's what I think
we have to do with linking Oracle tables.
-----Original Message-----
Since the PK is defined in each of the four tables in SQL
Click to expand...
Server, upon relinking to those tables, I get a "All
selected linked tables were sucessfully refreshed"
dialogue. I do not get prompted for "Select Unique
Identifiers." The query's recordset is still not
updateable.
 
If you open the linked tables in design view, do you see primary keys?

--
Duane Hookom
MS Access MVP


Arco said:
Since the PK is defined in each of the four tables in SQL Server, upon
Click to expand...
relinking to those tables, I get a "All selected linked tables were
sucessfully refreshed" dialogue. I do not get prompted for "Select Unique
Identifiers." The query's recordset is still not updateable.
 
Yes. When opening each of the four tables, I first get the "Table 'TableA' is a linked table with some properties that can't be modified" dialogue. The table design does open and the PK does have a "key" icon next to it

----- Duane Hookom wrote: ----

If you open the linked tables in design view, do you see primary keys

--
Duane Hooko
MS Access MV


Arco said:
Since the PK is defined in each of the four tables in SQL Server, upo
Click to expand...
relinking to those tables, I get a "All selected linked tables wer
sucessfully refreshed" dialogue. I do not get prompted for "Select Uniqu
Identifiers." The query's recordset is still not updateable
 
Back
Top