I'm having trouble figuring out how to easily "update" or "requery" my tables (not forms) in Access 2010/2007 without having to re-import it every time I need updated tables. Note that "refresh" is not what I'm looking for.
I read extensively online and nothing works for me. I read a few articles on how to requery "forms" (not tables) and other articles with codes that don't do anything for my tables. Even MS's website's Refresh/Requery help section refers to requering "forms" and not tables. Does anyone have a macro or know an easy way to automatically or semi-automatically update the tables to have most recent data on them?
This the most promising turotial I found, but I'm unable to get it to work:
[It doesn't let me post links; perhaps I can PM you]
It doesn't do anything when I run it, and possibly the function call (
RefreshODBCLinks) parameters are not for my setup. I'm not sure what they are.
I read extensively online and nothing works for me. I read a few articles on how to requery "forms" (not tables) and other articles with codes that don't do anything for my tables. Even MS's website's Refresh/Requery help section refers to requering "forms" and not tables. Does anyone have a macro or know an easy way to automatically or semi-automatically update the tables to have most recent data on them?
This the most promising turotial I found, but I'm unable to get it to work:
[It doesn't let me post links; perhaps I can PM you]
It doesn't do anything when I run it, and possibly the function call (
RefreshODBCLinks) parameters are not for my setup. I'm not sure what they are.