flscotty1

Saw that you plan to split the DB - put it on the WEB.
This will probably lead you to SQL Server and AZURE.
Just wanted to give you a tip. Use SQL Server.
To link tables to use either version, consider using DSN-Less tables with SQL Server Native Client 11.0
We have posted regarding this subject.
An example of the code might look like this:
strConnectionString = "ODBC;DRIVER=SQL Server Native Client 11.0;" & _
"SERVER=productionsql\MyServer;DATABASE=" & DatabaseName & ";" & _
"UID=" & UID & ";" & _
"PWD=" & pwd & ";" & _
"Table=DBO." & sLocalName & ";Option=3;"