Recordset not updateable. Access F-end SQL2000 B-end

[messmerized]

Hi

I recently finished!!! my Access database and then got asked to put it on an SQL server for the group to use. Disaster struck.

I managed to split the database ok, then using SQL created a new db and imported the tables only. Next, replicated (merge replication) the database out to the Access front ends where the forms, queries and macros sat.

Problem is forms using queries to fill fields give the error "recordset not updateable" I can browse up and down existing records but can make any changes or additions.

Simple forms using tables only, work great. So far I have tried setting the query property "unique records" to NO, removing distinct from the Queries, No joy so far.

Any clues would be really appreciated
Chin Chin

 

[jfischer]

Check the indexes on the SQL tables. Lack of an index can cause an update problem in Access.

 

[messmerized]

Thanks for the pointer.
Added SQL Indexes still no joy, However Your suggestion got me thinking of indexing in general. It turned out to be the relationships at the front end. When deleting some tables to allow SQL to replicate new ones the relationships were also deleted. Ive now recreated these and were up and running.

Do I feel a nummy.

Thanks for your help with this.
ChinChin