Updating Linked Table from Another Access Database

[Jeff C]

Using Access 2003 and I get "Operation must use an updateable query".

I have a table from another Access 2003 database on the same drive linked
into a second database and want to update a field in the linked table using
an update query in the second database.

I know its not possible linking to Excel but what's the issue with the
Access database? I do with a SQL table all the time. Any ideas appreciated.

Thanks in advance.

[Jerry Whittle]

http://support.microsoft.com/?kbid=328828

This is a very complicated subject. I suggest that you open up Access Help,
go to the Find tab, type in "updatable" (lower case u) or "About updating
data", and then scroll down to "When can I update data from a query?" or "Why
can't I edit data in my form?". There you will find a lot of, possibly too
much, information on the subject. In a nutshell, if the query is based on one
table or tables with a one-to-one relationship, you will be able to edit or
delete records. If it is based on two or more tables with a one-to-many
relationship, you 'should' be able to edit or delete records. If you have
three or more tables based on many-to-one-to-many relationships, you will not
be able to edit or delete records. This is just the highlights. Help has much
more information.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Post by Jeff C
Using Access 2003 and I get "Operation must use an updateable query".
I have a table from another Access 2003 database on the same drive linked
into a second database and want to update a field in the linked table using
an update query in the second database.
I know its not possible linking to Excel but what's the issue with the
Access database? I do with a SQL table all the time. Any ideas appreciated.
Thanks in advance.
--
Jeff C
Live Well .. Be Happy In All You Do

[273.15]

Post by Jeff C
Using Access 2003 and I get "Operation must use an updateable query".
I have a table from another Access 2003 database on the same drive linked
into a second database and want to update a field in the linked table using
an update query in the second database.
I know its not possible linking to Excel but what's the issue with the
Access database? I do with a SQL table all the time. Any ideas appreciated.
Thanks in advance.
--
Jeff C
Live Well .. Be Happy In All You Do