Recordset is Not Updateable

A

Arco

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
 
M

Mark

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
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.
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.
 
M

Mark

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
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.
 
D

Duane Hookom

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
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.
 
A

Arco

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
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top