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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updating an external table 3
update problem 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
updated field 3
linking to SQL Server db table 6
FindFirst with external db not working 1
Copy a table in an external database 1
update time value issue 7

Back
Top