Recordset not updatable

[jamespeters01]

I am using 2 tables in my query and having the above message come up every time I try to populate one of the fields thru the query.

Have tried all sorts of possibilities, no index's, no primary keys etc etc but am getting nowhere. When I use a query from either one of the tables on there own I have no problem, its just when I try and use both of them together.


any ideas ??

 

[KenReay]

Hi

Some queries are just not updatable (eg aggregate queries), without seeing your query it is difficult to comment, but basically you will have to amend it so it is updatable, or think of a way to update the underlying tables directly.

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK