• 512-991-7197
  • This email address is being protected from spambots. You need JavaScript enabled to view it.
  • Always Open

Welcome to Microsoft Access Tips & Tricks

How to update External MS Access table


Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

When linking to external MS Access DB without table link, you may have some problem updating, deleting or inserting the records.

The solution for this is using the object Access.Docmd.

Here is statement to do it, it is pretty easy and handy.

With Access.DoCmd
      .RunSQL "your update/insert/delete statement"
End With

for example:

With Access.DoCmd
      .RunSQL "update tableA in 'c:\db_data.accdb'"
End With


Recommend other relevant articles:

 

 

© 2019 Austin Laptop [AustinLaptop.Com]. All Rights Reserved.