Run Access macro from vbscript

[FancyPrairie]

I need to open an access database and run some code which, in turn, prints a report.

I've searched the net for examples and many of them indicate the following code works. But when I run the script I get the error: ActiveX component can't create object: 'Access.application'

How do I resolve this issue?

set objaccess = createobject("Access.application") 
objaccess.opencurrentdatabase ("E:\dev\db4.mdb") 
objaccess.run "macro1" 
objaccess.CloseCurrentDatabase 
set objaccess=nothing

 

[Remou]

Is it only Access that gives this problem? Does, say, Excel, work ok?

I find that the code you show works for me.

http://lessthandot.com

 

[Remou]

It also occurs to me that you may have more than one version:

set objaccess = createobject("Access.Application.9")

http://lessthandot.com

 

[FancyPrairie]

That could be the problem (more then one version). Am extremely busy right now, but will give your idea a try when time permits.