Access Runtime - 429 ActiveX component can't create object 1

[T111]

I have a visual basic program complete and worked fine with Access 2000 as the database. Then when I uninstalled Access 2000 and install Microsoft Access 2000 Runtime I got an error when I came to the following line of code

Set objAccess = CreateObject("Access.Application&quot

The error generate is
Error Number = 429
Error Description = ActiveX component can't create object
Note - objAccess is defined as Private objAccess as Object

I am allowed to read, display and add records to the access database but not allowed to create an object of type Access.Application for displaying the reports since the reports are also done in access. The program has no problems with the full version of Access but with the runtime version I feel some dll files or something are missing.

Any help greatly appreciated!

 

[johnwm]

Access runtime isn't Access!. There are licensing issues involved. If you could open the full functionality of Access with the runtime version, you'd never need the full version.

Do a search on the forum, I'm sure I've seen other methods of referencing Access reports

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[T111]

Here’s the solution. There are two different ways to view an access report. One way displays a report for Access 2000 and the other for Access 2000 Runtime.

http://support.microsoft.com/support/kb/articles/Q210/1/32.asp

 

[jadoogar]

I dont think this is specific with access or anything
It seems to be with ado control I am facing same error when i run a VB program from client machine where I am unable to register msado15.dll in programs files common ado directory

I recompiled the VB using activex 2.0 library and got problem solved