How to update External MS Access table

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