update problem

A

Art Vandaley

Hi,

I would like to change (update) Data of a field of an external table which
belongs to a
database located in the server. The address is something like:
\\server\folder\md1.mdb . Let's say value of any row of field1 will be
updated. How can
I write the code? Regards.
 
V

Van T. Dinh

Use the IN clause in your Update Query to specify the target MDB in which
the Table to be updated locates.

Check the IN Clause in the JET SQL Reference section of Access Help.

If you want to run the Update Query by VBA code, you can use the OpenQuery
Method or the Execute Method.

Check Access VB Help on these 2 methods.
 
Top