Accounting System

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know of any good Access based accounting applications?

Thanks
 
I looked for a long time and could not find anything better than a basic
ledger. I was not able to Find a double-entry accounting package in Access
and had to resort to purchasing one.

Rick B
 
What did you end up purchasing?

Rick B said:
I looked for a long time and could not find anything better than a basic
ledger. I was not able to Find a double-entry accounting package in Access
and had to resort to purchasing one.

Rick B
Click to expand...
 
Rob said:
Does anyone know of any good Access based accounting applications?

Thanks
Click to expand...

Having worked in auditing for over 30 years I picked up the accounting
responsibilities for a club I belong to when I retired. I started looking
for an Access based system and did not find anything usable. I started
working on one and then I decided to update my MS Money program. I decided
to get the business version of it and take a look at what they had. It
turns out that I quickly decided to use MS Money rather than build my own.
I might add that I have two files, one personal based and one business based
and the two are kept separate.

It is not what I would call a full service accounting system, but it
should work for most small businesses.
 
The very popular Simply Accounting is JET (mdb file format) based. I believe
the actual application was written in VB, but the data part is in fact a
ms-access file. Documentation for all of the tables etc. is included with
the product. If you know ms-access well, then you can write some neat stuff
to open up the simply accounting data file, and grab data. However, I don't
believe it is very practical to insert data from ms-access into the
accounting system directly, as your knowledge of the table structures etc,
and adding of primary keys etc would take too much work.

However, the data is in ms-access format..and can be easily used. The other
day, a client of mine needed a list of "accounts" for a dropdown box. That
"list" of accounts was actually in simply accounting, and I just wrote some
code to "transfer" this data (list of accounts) from the Simply to my
application.

You can download and run the trial edition. (I am currently doing that
now...and like what I see).

http://www.simplyaccounting.com/


There is also "Yes, I can run my business". This is ms-access based, and
source code is available.
http://www.accountingsuccess.com/index.htm

There is also Traverse. This is ms-access based, and source code is
available.
http://www.traverse.ca/
 
Could you please tell me how to open a Simply Accounting data file in MS
Access? I am working on a project in Access to transfer data from Simply
Accounting. When I open a SDB file in Access I got the error as "You don't
have the neccessary permission to open the file..." Thanks in advance.

Jerry
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Migrate IMAP Email to Office 365 Easily 0
Spam, disgusting accounts being created!! 5
Is there any client for Google Drive based on Linux? 2
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Firefox Multi-Account Containers 1
How to migrate Gmail to Office 365? 2
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Offline Photo Organisation Software 9

Back
Top