Link to home
Start Free TrialLog in
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.
ASKER CERTIFIED SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Tony
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.
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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial