Re: Trying To Use Migration Wizard...

> -----Original Message-----
> From: Paul Malinowski [mailto:paul(dot)malinowski(at)wulfsberg(dot)com]
> Sent: 15 October 2002 23:50
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Trying To Use Migration Wizard...
>
>
> Hi,
>
> I'm trying to use the DB Migration Wizard to migrate an MS Access 97
> .mdb database to postgres 7.2.2 running on a RedHat 8.0 system. The
> following is the message from the log file.

> 2002-10-15 15:39:20 - Error in Database Migration Wizard:Database
> Migration Wizard:frmWizard.dbConnect: -2147217843 - Cannot start your
> application. The workgroup information file is missing or opened
> exclusively by another user.

Hi Paul,

The problem is that the Wizard cannot open the .mdw file. There is an
item on the todo list to allow selection of the file, but I don't know
when that will happen (or how for that matter - I know very little about
Access). Probably the best bet is to try one of the following:

1) Make sure the .mdw file is in the same location as the .mdb. If that
doesn't work, try dropping it in the pgAdmin working directory.

2) Copy the database and remove the security using access. If there is
no security the MS Jet engine won't need to access the mdw file.

Regards, Dave.