Access 97 to SQL 2000 conversion

M

maestrodb

I am trying to convert an access 97 database to sql 2000
but I am getting the following error message.

DTS IMPORT/EXPORT WIZARD ERROR
ERROR SOURCE: MICROSOFT JET DATABASE ENGINE
ERROR DESCRIPTION: RECORD(S) CANNOT BE READ; NO READ
PERMISSION ON 'MYDATABASE.'
CONTEXT: ERROR CALLING OPENROWSET ON THE PROVIDER.

I know that this particular database has a password but is
there a way to get around this password issue because I
don't know what the password is - my predecessor didn't
leave any documentation whatsoever so I am left trying to
figure this thing out. At any rate, any help would be
much appreciated.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top