Link Act!2000(5.0) to Access2002?

[HughMul]

Can anyone tell me how I can link (not export) an Act!2000 (version 5) database to an Access 2002 database. There are apparently no ODBC drivers for Act. Crystal Reports 8.5 has a native driver for Act but I don't know how to use it other than in Crystal. Interact publishes an SDK for Act but there are no instructions for creating a vba module in Access. I am primarily interested in reading from, not writing to the Act database. Any KB links, FAQs or other information would be appreciated. Thanks.

 

[mccotter]

Has anyone found a solution to this problem?

Thanks in advance.

--Marc

 

[MitchCumstein]

You can create your own ODBC link based on the dBase driver. AFAIK, it will be read-only

 

[Storyteller]

Hello All,

Take a look at this:

http://www.photoact.net/actaccess/

I am using it to link ACT! 5.0 to Access 2000. (I'm even trying it with a runtime version of Access)

Regards,
Michael

 

[mccotter]

Thank you so much for the suggestions. I just downloaded ActAccess and I'm going to give it a shot. This is great because I would love to keep the contacts in Access and just use Act! as a frontend to the data.

Does anyone know if there is a similar product to link Act! and the data stored in MS SQL Server?

Thanks again.

--Marc