troubleshooting Question

Accounting Period....

Avatar of Tony
Tony asked on
DatabasesMicrosoft AccessMySQL ServerVBAAccounting
6 Comments4 Solutions75 ViewsLast Modified:
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.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 4 Answers and 6 Comments.
Start Free Trial
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.

-Mike Kapnisakis, Warner Bros