Accpac and Access ODBC?

[pronate]

Hi,

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?

Cheers
Sam

 

[AlexJhb]

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

 

[pronate]

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
Sam

 

[AlexJhb]

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.