Link to home
Start Free TrialLog in
Avatar of rrowe68

asked on

Deployment of Visual Basic 2005 Application with Access Runtime Issues...

I have an applicaiton Visual Basic 2005, that prints an Access Report that resides on a local server.   It works at the client when the full Access 2003 is installed.

Users here at EE have indicated that installing Access Runtime 2003 might do the trick also.   Yet, I am running into the following error.

Retrieving the COM class factory for component for CLSID {73A4C9C1-D68D-11D0-98BF-00A0C90DC8D9} failed due to the following error: 80080005.

This CLSID is Microsoft Access.

Do I need to really buy licenses for all my workstations to print these reports?

Here is the code that calls the report....  Any other way to call the report?

            Dim oAccess As New Access.ApplicationClass
            oAccess.OpenCurrentDatabase(filepath:=eAccessPath, Exclusive:=False)
            strWhere = "nMemoID = " & CURRMEMO & " AND " & "lPropertyID = " & CURRPROP
            oAccess.DoCmd.OpenReport(ReportName:="prMemo", View:=Access.AcView.acViewNormal, WhereCondition:=strWhere)
            oAccess = Nothing
        Catch ex As Exception
            MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning)
        End Try

Open in new window

Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

>>Do I need to really buy licenses for all my workstations to print these reports?

Yes. This is why Access reports are not the best choice!
Avatar of rrowe68


So what do you suggest Crystal Reports?
You CAN automate with Access runtime.
You can't use New.

See here:
Avatar of rrowe68


Thanks for the responses....

Peter57r, if you can't use NEW, what is the code to use>?
Avatar of peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
>>you must start the Msaccess.exe and specify a database to open

doesn't that means that Access needs to be installed?