• 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.