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.
AccountingDatabasesMicrosoft AccessVBAMySQL Server
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
Hi Pcelba.... very good input. Thank you very much.
I will still need however guidance on how to implement this.
"The implementation is on you and many ways exist. ".... Can you suggest some of the ways... or a least an efficient one?
Thank you.
Pavel Celba
No, I cannot help here because I don't know your data structures and your country/company rules may define something which I am not aware of.
I don't know whether you are accountant or programmer or both... These two people must work closely together. Accountant will describe each single step of the period closing/opening and programmer which knows the data internals will write a piece of code based on these instructions.
More people are necessary between accountant and programmer sometimes. Large companies need architects and other positions able to convert the accountant's language to programmer's language. If you are in a small company you may do everything yourself but yo have to understand all parts of this process. To explain everything is out of the scope of this forum.
Unlimited question asking, solutions, articles and more.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
I will still need however guidance on how to implement this.
"The implementation is on you and many ways exist. ".... Can you suggest some of the ways... or a least an efficient one?
Thank you.