I am attempting to build an accdb file from vb script and getting the following err.
Screenshot:
http://www.screencast.com/t/6zR7qY740X
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.OL
EDB.12.0;D
ATA SOURCE =" & strFileName & ".accdb" & ";"
Set objCatalog = Nothing
MsgBox "Done"
How can I overcome the err?
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.