Обсуждение: DB Migration Wizard error opening MDB file

I made a local copy of a network shared database.
When I run the Database Migration Wizard (current version of PgAdmin2 and the
Migration Wizard) it asks for the Access .mdb file, username and password.  I
put them in (for administrator).

Then a dialog pops up asking for the MS JET OLE DB Initialization Information.
I don't know what to put in the Provider String slot and I've tried a couple
read only and read write opening modes.  I always get this error back:

An error has occured in Database Migration Wizard:Database Migration
Wizard:frmWizard.dbConnect:

Number: -2147217843
Description: Cannot start your application. The workgroup information file is
missing or opened exclusively by another user.

The shared version of the Access file out on the network requires a username
and password to access it.  The local copy doesn't (when using Access).

I've tried leaving the username and password blank but then it moves forward
to eventually give me a read permission error.

I'd love to try this wizard but I'm stumped!  Please help if you know the way
around these Access databases.  I'm not at all savvy about them.

TIA,
Scott

On Wednesday 07 May 2003 13:26, Scott Chapman wrote:
<snip>
> I'd love to try this wizard but I'm stumped!  Please help if you know the
> way around these Access databases.  I'm not at all savvy about them.

I figured out how to do this.

I made a local copy of the database by importing from the one that PgAdmin
couldn't get into and it moved forward.  Now I get "An error occured at: DATE
& TIME
5:Invalid procedure call or argument."

I turned up the logging to level 4 on PostgreSQL but I don't see any error
messages there to give me a clue as to what the problem is.  As it turns out,
the two times this has happened have been empty tables so I think this might
be a bug?

Scott

> -----Original Message-----
> From: Scott Chapman [mailto:scott_list@mischko.com]
> Sent: 07 May 2003 22:10
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] DB Migration Wizard error
> opening MDB file
>
>
> On Wednesday 07 May 2003 13:26, Scott Chapman wrote:
> <snip>
> > I'd love to try this wizard but I'm stumped!  Please help
> if you know
> > the way around these Access databases.  I'm not at all savvy about
> > them.
>
> I figured out how to do this.
>
> I made a local copy of the database by importing from the one
> that PgAdmin
> couldn't get into and it moved forward.  Now I get "An error
> occured at: DATE
> & TIME
> 5:Invalid procedure call or argument."
>
> I turned up the logging to level 4 on PostgreSQL but I don't
> see any error
> messages there to give me a clue as to what the problem is.
> As it turns out,
> the two times this has happened have been empty tables so I
> think this might
> be a bug?

Can you send some full debug logs from pgAdmin please? Log settings are
under Tools -> Options.

Regards, Dave.