Hey Bob, I think you just helped me figure out what was wrong! I was following someone else's guide on how to import/link (not sure which word was used in the guide), and after a full stomach I see that there are two options to display SQL data in Access, "import" and "link." I just created a...
The tables are already linked to the SQL database, and they show only the current data at the time of linking (sorry for the poor choice of work, import). They do not get updated as the SQL database gets modified. I will need to do this everyday, and it will be an annoyance to click and click...
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...