[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 964
  • Last Modified:

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

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
jbpowell
Asked:
jbpowell
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now