I have a database (accounting database). MS-Access as Front End and Mysql as Back-end.
In accounting, it is a routine to close periods (fiscal year, for instance). In doing this, normally a new database is set up with the Ending balances (now beginning balances) for the new fiscal year.
The implications of this is that:
1. A new database is set (In mysql, in my case).
2. A new ODBC Connection needs to be set.
How can I automate this using MS-ACCESS and Mysql? To make it userfriendly and easy to use. How Can I open a new database in Mysql from Ms-Access? Possible?
If you have accounting knowledge or knowledge of accounting software you will know what I am talking about.
If not, I will explain more.