ODBC Connections

[bbal20]

Currently, my companies tables are structured splitting everything up in
monthly tables. Is there a way to have my odbc connection into MS Access
change at the beginning of every month based on the naming convention of the
table in our MySql environment. The Tables are currently named
RPT_DAY_GUI_200906 representing June 2009.

 

[Jeff Boyce]

I'll take the keyword in your description to be the first word, "currently".

If you want to get the best out of Access' relationally-oriented
features/functions, you need to 'feed' it well-normalized data.

Having a separate table for each month's data is NOT well-normalized.

Is there a possibility that you could create a new table in Access that
holds all the fields, plus one more, the "reporting-month"?

Then you could use a query to load the raw data (your "monthly" tables) into
that more permanent Access table, and use Access' capabilities to do your
reporting...

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP