When (trying) to access an ACT! 200 1

[eticket]

When (trying) to access an ACT! 2000 database using Crystal Reports 9.0 we get 2 dialog boxes, the first being "not supported", then the next being "data object cannot be opened/accessed". Has anyone else run across this? We were able to access the database using 8.5 without any difficulty.

 

[synapsevampire]

Here's the CD FAQ saying that it's supported:

http://support.crystaldecisions.com/library/kbase/articles/c2011814.asp

Are you using btrieve, or???

Have you tried a verify database?

-k

 

[eticket]

What's verify database? Please excuse my ignorance, I'm a SQL and web developer. This is my first foray into the Crystal world.

 

[synapsevampire]

Under Database->Verify Database.

You can also change drivers/location of the data using Database->Set Location.

-k

 

[eticket]

You are talking version 9.0 right? So far we can't even connect. Can you tell me the menu options required for this, like file, open...?

 

[eticket]

Okay we opened the report then did a database verify and we got the same error messages

 

[synapsevampire]

Did you try the Set Location and repoint to the datasource?

-k

 

[eticket]

Yup. Same errors.

 

[chelseatech]

I can't get my CR9 to view my Act!2000 data either. Either a new report or my existing CR8.5 reports.

So I'm keeping my Act reports in Cr8.5

I've found CR9 has major problems with connecting to some Db's including Act and Progress. Wait until a service release sorts it out.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[eticket]

Well alright then. Thanks for trying. Have you had any success contatcing Crystal for support?

 

[IdoMillet]

I believe this is a known issue (with secure ACT databases) that has been fixed in the following patch:

ftp://ftp.crystaldecisions.com/outgoing/EHF/CR90DBEXWIN_EN.ZIP

Note: the usual precautions about installing patches apply... )

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[eticket]

You believe correctly, Obi-Wan Millet. Patch applied, fix in. Much thanks to you, Synapse and Chelsea.

 

[IdoMillet]

eticket,

Glad it fixed your issue )

Could you please search your PC and let me know if you see the following dll anywhere: P2ctact3.dll

CR Documentation lists this dll as required for ACT! but it doesn't seem to exist.

Cheers,
- Ido (Kenobi)

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[eticket]

Sorry for the delay. No I did not find the file on the PC running Crystal, or any others for that matter. What's it required for?

 

[chelseatech]

Ido,

That deserves a star. I do a bit of work with Act reports, and use it in my company, so great to see I can use it with CR9 at last.

Regards

bruce


Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[IdoMillet]

Thanks, Bruce... )

Eticket, that dll is listed by Crystal (in one of their tech documents) as required for connecting to Act! databases with CR 9, but as you (and one of my customers) demonstrate, it doesn't seem to be needed (nor is it installed by Crystal).

I have an open case with Crystal asking them to clarify.

Cheers,
- Ido



CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com