update problem

  • Thread starter Thread starter Art Vandaley
  • Start date Start date
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.
 
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.
 
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
Updating table an external db. 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
form won't update, what to check 2
Adding a folder results in error in currently working database 4
Numbering of duplicates 3
Updating tables when you input new data 0
Need to change physical location of Externally Linked Tables - Possible to fake out network server l 2

Back
Top