Connection from MS Access

[gregoryvain]

Hello,

I would like to connect to accpac from VBA in MS Access. I have tried some of the code that you have posted in this forum and it gives me errors.

There are 2 things that I am concerned about:
1) The accpac database runs on a server, not on the computer that I am running the access database on, but the computer does have Accpac installed obviously.

2) I am not sure what references I have to include in order for the code to work.


All the code that you find on the net describes how to connect to the 'Accounts Receivable' tables, I would like to connect to the Assemblies table.

Thanks for you help

 

[jayconverse]

As always, record a VBA macro within Accpac that accesses the tables you want to work with. This will give you the views and compositions you need. Then copy that into your MSAccess code.

Jay Converse
IT Director
Systemlink, Inc.

 

[zemp]

You will need to reference the ACCPAC COM API Object 1.0 library.

zemp