What I wanted to do is to have ERwin to reverse engineer an Access db
to generate a MS SQL Server 2000 -compatible SQL DDL script. I'll use
it to create tables, keys, indexes (and having ERwin to capture
Access's TABLE/FIELD DESCRIPTIONS) etc structure on a target SQL Server
2000 db, then using DTS to import data in from the Access DB. (Haven't
used ERwin for a while, would not expect it to be able to convert
Access queries and VB-driven modules(funcitons) into sql equivalent).
So, I'll take care of that part of functionality conversion myself.
However, I'm having a hard time connecting to Access db from ERwin,
here's how I tried, in ERwin, under Tools menu, choose Reverse Engineer
then select Access 2000 (since there's no choices/options for 2002
and/or 2003), then prompted with db connection inputs including
username, password, database, system database and password. The last
two items of system database and password ticks me off. What the heck
is system database in Access (fyi, I'm not an Access expert,
comfortable though). Leaving them blank while attempting to connect
generates error. CA web site is useless in getting helpful info on
resolving the issue.
TIA.