Visio cannot create table in Access database (ODBC error 42000)
Posted on 2004-09-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.