Can't Export to Database (MS ACCESS 2002)

[Jean]

Hi,

I am using Visio 2003 Professional. Just created a data model and try to
export to a blank MS ACCESS database. But always got this error. There is
no admin password for the database.

ODBC Error: 42000
[Microsoft][ODBC Microsoft Access Driver] You do not have the necessary
permissions to use the 'NewTable' object. Have your system administrator or
the person who created this object establish the appropriate permissions for
you.


Thanks

Jean

 

[Al Edlund]

you can't export a data model from professional, you have to be at
enterprise architect. you can however use the database wizard to export the
objects (not ddl).
al

 

[NG]

I am having the same problem even though I am using enterprise architect.
May be I am doing the wrong thing:
I am trying : Tools -> Export to Database ... menu option. Then selecting
the excel in combo.
The database does get created with some table but it shows some fields from
somewhere.
Can you pls help me with the right process of exporting the database to a
access database.

Thanks
NG

you can't export a data model from professional, you have to be at
enterprise architect. you can however use the database wizard to export the
objects (not ddl).
al

Hi,

I am using Visio 2003 Professional. Just created a data model and try to
export to a blank MS ACCESS database. But always got this error. There is
no admin password for the database.

ODBC Error: 42000
[Microsoft][ODBC Microsoft Access Driver] You do not have the necessary
permissions to use the 'NewTable' object. Have your system administrator
or
the person who created this object establish the appropriate permissions
for
you.


Thanks

Jean

 

[Al Edlund]

the database wizard in professional exports the drawing, not a data model...
al

I am having the same problem even though I am using enterprise architect.
May be I am doing the wrong thing:
I am trying : Tools -> Export to Database ... menu option. Then
selecting
the excel in combo.
The database does get created with some table but it shows some fields
from
somewhere.
Can you pls help me with the right process of exporting the database to a
access database.

Thanks
NG

you can't export a data model from professional, you have to be at
enterprise architect. you can however use the database wizard to export the
objects (not ddl).
al

Hi,

I am using Visio 2003 Professional. Just created a data model and try
to
export to a blank MS ACCESS database. But always got this error. There is
no admin password for the database.

ODBC Error: 42000
[Microsoft][ODBC Microsoft Access Driver] You do not have the necessary
permissions to use the 'NewTable' object. Have your system administrator
or
the person who created this object establish the appropriate
permissions
for
you.


Thanks

Jean