creating accdb file from vb script

I am attempting to build an accdb file from vb script and getting the following err.


I intent to run this on machines that do not have Access installed.  I tested on a machine that did have Access 2010 and still get the err.

VB Script:
strFileName = InputBox("Enter Access File Name",, "MyAccessDatabase")

Set objCatalog = CreateObject("ADOX.Catalog")

'objCatalog.Create "PROVIDER=Microsoft.ACE.OLEDB.12.0;DATA SOURCE =" & strFileName & ".accdb" & ";"

Set objCatalog = Nothing

MsgBox "Done"

How can I overcome the err?
Keith McElroyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Professor JMicrosoft Excel ExpertCommented:
you are probably running this from Windows 7 64 bit
Windows 7 doesn’t have a driver that will run VBS files in 64 bit, you need to make the vbs run in 32 bit. This can be accomplished by  opening your command prompt go on run and type cmd and then enter
then paste
%windir%\SysWoW64\wscript.exe C:\Users\yourmachineusername\Desktop\CreateBlankDatabase.vbs

Open in new window

and enter.  

you can change the "yourmachineusername" to your username and also the file path. the above one is assumed that file is in Desktop.

it will work.

let me know how it goes.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Keith McElroyAuthor Commented:
Yes, it works now, I also downloaded and installed the Microsoft Office Compatability Pack which seemed to help as well.  Thanks a bunch!
Professor JMicrosoft Excel ExpertCommented:
you are welcome Max. thanks for the feedback
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.