Avatar of Tony
Tony
 asked on

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.
AccountingDatabasesMicrosoft AccessVBAMySQL Server

Avatar of undefined
Last Comment
Gustav Brock

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Pavel Celba

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
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.
ask a question
SOLUTION
Dale Fye

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
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.
ask a question
Tony

ASKER
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.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
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
William Peck