troubleshooting Question
Accounting Period....
Hi.
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.
Please advice.
Thank you.
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.
Please advice.
Thank you.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 6 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.