ADOX.CatalogClass.Create Error

Posted on 2009-12-18
Last Modified: 2013-12-25

some of our users are getting the following error message when they first try to run our program:

Additional Description: Error Creating User Settings Database
Stack Trace: at ADOX.CatalogClass.Create(String ConnectionString)

When it is first run, the program looks for a "User Settings.mdb" database (in MS Access format) and tries to create one if there isn't already one present.

In order to programmatically create a Jet database, the program references:
  Microsoft ADO Ext. 6.0 for DDL and Security

and I include "msadox.dll" from the "ADO" folder in the "Common Files\System" folder and the "Interop.ADOX.dll" created by my project into the installer.

The program also references:
   Microsoft Jet and Replication Objects 2.6 Library

so the "msjro.dll" and "Interop.JRO.dll" DLLs are also included in the installation.

I assume that this error is occurring because the client's system isn't registering these dll's properly and/or I am not installing them correctly, or am missing something.  What can I do?  Thank you.


Question by:vdurbal
    LVL 29

    Expert Comment

    Can you show us the piece of code where you are actually doing this.


    Author Comment

    I'm not sure what you mean.  The DLL's were added using the "Add Reference" menu option, then selecting the following references on the "COM" tab:

          Microsoft ADO Ext. 6.0 for DDL and Security
          Microsoft Jet and Replication Objects 2.6 Library

    In our installer, I included those DLLs and on almost everyone's machine, the installation is fine and the program works.  The error I am describing only happens on one or two machines.  The latest one is running Windows XP Tablet Edition.

    Also, I tried installing the MDAC downloaded from Microsoft, but it didn't make a difference.

    I hope this helps.  Please let me know what else you need to diagnose the problem.  Thank you.

    LVL 10

    Accepted Solution

    Do you know what version of ADOX is on their machine before you installed your program?
    Why are you using ADOX to create a Jet database?  The DAO CreateDatabase command should work. There are all sorts of problems with ADOX.

    Author Comment

    Thanks.  I'll try using the DAO command.

    Author Closing Comment

    I'm only giving a B because my original question was not answered, but the accepted answer could be a reasonable workaround.  Thank you.
    LVL 10

    Expert Comment

    Glad you liked my solution.
    FYI, not sure if it helps but our Total Visual SourceBook product has lots of royalty-free source code related to creating and managing Access databases, workgroup security, passwords, etc.  It's a commercial product, so I know that may not be an option but you may find it helpful.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now