Access denied CR XI sp 4

[Former Member]

Use Crystal XI version 1, vb6 and access.

Sometimes (not always) when I print generare a error -2147189176 Access danied

Do not print and are forced to exit from the application.

The istruction generare error is Report.printout False,2

I have upgrade with sp4 but the problem is not solved.

Tank you for help

[former_member183750 · Accepted solution]

Two things I'd recommend:

1) Ensure you are setting the report object to nothing once you are done with it

2) Upgrade to CR XI release 2

CR XI r2 can be downloaded from here:

https://smpdl.sap-ag.de/~sapidp/012002523100006008462008E/crxir2.zip

Uninstall CR XI r1 first, then install r2. Use the same keycode you used with your current r1. Then apply SP 5 from here:

https://smpdl.sap-ag.de/~sapidp/012002523100013876392008E/crxir2win_sp5.exe

Ludek

[Former Member · Accepted solution]

When I distribute the application to do something different from CR XI rel. 1 ?

I can use them .msm are different ?

tanks

[former_member183750 · Accepted solution]

See [this|https://wiki.sdn.sap.com/wiki/display/BOBJ/CrystalReportsReportDesignerComponentRuntimeDistribution-Versionspre8.0.xto12.0] wiki for the correct msm download.

Ludek

[Former Member · Accepted solution]

The link for download

CR XI R2 (11.5) Y# Y MSM Download Link

not work

Tank

[former_member183750 · Accepted solution]

Here is the link:

https://smpdl.sap-ag.de/~sapidp/012002523100004610732009E/crxir2fp52_rdc_mm.zip

I'll update the wiki asap.

Also, remember you can search for any downloads here:

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/bobj_download/main.htm

Ludek

[Former Member · Accepted solution]

Crystal reports XI R2 is in Italian language ?

tank

[former_member183750 · Accepted solution]

It is an MLB product and on install you should be able to choose your language. See [this|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_erq/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes.do] note for more info.

Ludek

[Former Member · Accepted solution]

I downloaded everything and do a check.

Last question as I had problems with R1

CrystalreportViewer.Enableprogresscontrol = true because it did not work.

Now working?

There 'some examples?

bye

[Former Member · Accepted solution]

The problem is the same.

I removed crystal report XI R1.

I have installed crystal report XI R2 and SP5.

I modficato objects.

Dim Report As CRAXDRT.REPORT

Set Applicazionereport = CreateObject ( "CrystalRuntime.Application")

Dim tbl As CRAXDRT.DatabaseTable

For Each tbl In Report.Database.Tables

tbl.SetLogOnInfo db_name

Next

Report.RecordSelectionFormula = FILTRO_RPT

VIEW.ReportSource = Report

VIEW.ViewReport

Done so at times (not always) gives me ERRCODE -2147189176 "Access denied"

What can I do?

[former_member183750 · Accepted solution]

tbl.SetLogOnInfo db_name

That method has been deprecated since version 8.5 of Crystal Reports. In version 9, the whole database engine was rewritten and you now have to use the connection properties bag. [This|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/00635998-751e-2b10-9cba-f50ee1e4ef81] article describes connection properties in detail. Also, see the developer help file:

C:Program FilesBusiness ObjectsCrystal Reports 11.5Helpen dcsdk_com_dg_docdoc dcsdk_com_dg.chm

The [notes|https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_ossnotes&query=&adv=true]

database is a great resource also.

Ludek