I have a linked table in MS Access ( at local drive and the version is 2010 ) that is linked to a Share Point list at a remote site. I would like to be able to work offline to update the linked table in Access.
How could I programatically ( using vba ) update the linked table offline?
The code that I am using to update the linked table ( e.g. ABC ) is:
Db.Execute strSQL, dbFailOnError
When I programatically set "SetOnlineState" to False, when I execute the above line of code, a error occurs and the error message reads:
1. err.Number = 3907
Linked table 'ABC' is unavailable. Microsoft Access cannot contact the server. Check your network connection or contact the server administrator.
Would appreciate it very much your help to write a vba routine to handle offline / online mode for working with linked tables.