Updating table an external db.

  • Thread starter Thread starter Art Vandaley
  • Start date Start date
A

Art Vandaley

Hi,

I would like to change 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 field1 will be updated. How can
I write the code. Regards.
 
If it's a Linked table, then do it the same way you would
for a local table.

If, for some reason, you can't link to it, then use a query:
UPDATE table IN "\\server\folder\md1.mdb" SET field1 = 1

But, there's probably more to your question than updating
every record in the table.
 
Back
Top