Link to home
Start Free TrialLog in
Avatar of rrowe68
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?

Try
            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.Quit()
            oAccess = Nothing
        Catch ex As Exception
            MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning)
        Finally
 
        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
rrowe68

ASKER

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

See here:
http://msdn.microsoft.com/en-us/library/aa167790.aspx
Avatar of rrowe68

ASKER

Thanks for the responses....

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

Link to home
membership
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?