Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Accpac and Access ODBC?

Accpac and Access ODBC?

Accpac and Access ODBC?


I am a newbie to Accpac.

I have 2 databases. Accpac to do accounting and finance, Access to track inventory, workflow among departments.

My company wants to link our 2 databases together, Accpac and Access. Talked to my Accpac vendor, he says using ODBC will slow the system down, not advisable and suggests using a customised program that export data upon user request or event trigger.

Any one have experience in this?


RE: Accpac and Access ODBC?

Take it you want to pass the financial impact of your stock movements to the GL and possibly pass invoices to the subledgers AR & AP if you have them.

I suggest you do not write to the Accpac files using ODBC unless you know what you are doing and which of the multiple tables to update with what information to maintain integrity.

WE use the Accpac SDK to write to Ap and AR from external systems. We validate data before creating the entry directly into a batch. So we check for valid customer/supplier or GL account number before creating the entry. This validation is quite easy with ODBC as you just need to know the field to look up. But when you do the rest the rotaview will do the correct updates to the correct tables for you. For example, it will update batch totals when you write an entry and so on.

Anyway, the short answer is do it with the SDK and not direct ODBC to the tables unless you know what tables to update to maintain integrity.

Good luck

RE: Accpac and Access ODBC?

Thanks for the info.

Actually, i don't need to write to accpac data from Access. I just need to use the customer order enteries information in Accpac and write to the data table in Access, which are link to it by a order number....to track internal workflow and some inventory functions.

Do I still need SDK to customised it? I heard there is a version of ODBC (pervasive SQL...and it comes free) that provide only read function. If this is suitable for my need, i wonder how is its performance.

Currently, I don't link them, so there requires a double entry. I got over 10 years of data in Accpac, but in access, i transfer old data out and only keep those that are less than 1 year old, size is less than 10MB.

Thanks and cheers

RE: Accpac and Access ODBC?

Go to Control Panel, Administrative tools (Windows 2000) and Data Sources (ODBC) and create a DSN using the Pervaise engine and pointing it to the Accpac database.

From there you can link via Access to the tables. If you cannot find the fields, let me know exactly which fields you want in which modules and will see if I can help.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close