I'm not using Access to store the data itself. Just as a client to online SQL databases.
With ODBC drivers you can connect to most SQL databases including all the popular ones like MySQL, PostgreSQL, Oracle, MS, etc. I have one PostgreSQL database with a variety of complexly joined tables that I need to update each year. I can put the new data into Excel and upload the tables via Access. I can write SQL pretty fluently and typically use a text-mode client from the command prompt. Sometimes I find the ability to create visual queries helpful when the database structure is complex.
|