Solved

Visio cannot create table in Access database (ODBC error 42000)

Posted on 2004-09-01
1
915 Views
Last Modified: 2008-02-01
I'm attempting to run the Database Wizard in Visio.  It errors out when it's time to create the table in the Access database that I have created.  The full text of the error is below.

I don't have any security set up on the Access database in question, in other words I am not prompted with an Access login when opening this database.  Any suggestions?


ODBC Error: 42000
[Microsoft][ODBC Microsoft Access Driver] You do not have the necessary permissions to use the 'hardware' object.  Have your system administrator or the person who created this object establish the appropriate permissions for you.
0
Comment
Question by:jbpowell
1 Comment
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
Comment Utility
You ALWAYS log into an Access database with security, regardless of whether you've implemented it or not. The default security file is "system.mdw", the default user is "Admin" and the default password is blank.

You'll almost certainly need to Visio with the full path to the system.mdw file. You can do a file search to find the file, then write down the path and, from within Visio, go back through the connect options. I'm at work now, don't have Visio installed here but I do at home. Go back through your connection options and see if you can edit the connnection options and/or string to include the path to the system.mdw file, and also pass in the default user "Admin" and no password.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.

762 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

7 Experts available now in Live!

Get 1:1 Help Now