Thread: Re: Migrating mdw'ed MSAccess Database

> -----Original Message-----
> From: Anung B. Ariwibowo [mailto:barliant@yahoo.com]
> Sent: 12 August 2002 11:09
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Migrating mdw'ed MSAccess Database
>
>
>
> I have an MSAccess Database which is created using workgroup
> administrator under MSAccess (those *.mdw stuff). I created
> this database using MSAccess2000. When migrating this
> database to PostgreSQL, I first convert it to Prior Version
> of database (MSAccess97),

Why do you do this?

> then read the converted database in
> PgAdmin. However, when PgAdmin starting to migrating the
> database, I got this error
> message:
>
> Creating table: DownList
>
> An error occured at: 12/08/2002 16:36:13:
> -2147217911: Record(s) cannot be read; no read permission on
> 'DownList'.
>
> Rolling back... Done.
>
>
> I have tried to supply the correct user + password in the
> first step of Migration Wizard, but PgAdmin then shows a
> window titled "Please Enter MS JET OLE DB Initialization
> Information" with this fields:
>
> Data Source: mydb97.db
> User Name: Anung
> Password: *****
> Provider String: <this is empty>
> Open Mode: DB_MODE_READWRITE
>
> Do I have to fill in the Provider String field? What string
> should I fill?

No, you normally don't. Unfortunately I know very little about Access
security, but could this problem be caused by pgAdmin not using the
correct MDW file (this an item on my ToDo list)?

To work round it for now, can you remove all security from your copy of
the database just whilst you migrate it?

Regards, Dave.

--- Dave Page <dpage@vale-housing.co.uk> wrote:
>
> > -----Original Message-----
> > From: Anung B. Ariwibowo [mailto:barliant@yahoo.com]
> >
> > I have an MSAccess Database which is created using workgroup
> > administrator under MSAccess (those *.mdw stuff). I created
> > this database using MSAccess2000. When migrating this
> > database to PostgreSQL, I first convert it to Prior Version
> > of database (MSAccess97),
>
> Why do you do this?

converting first to Access97? When I first time tried to migrate one of
my Access2000, PgAdmin didn't successfully migrate it. So I usually
convert it to Access97.

> No, you normally don't. Unfortunately I know very little about Access
> security, but could this problem be caused by pgAdmin not using the
> correct MDW file (this an item on my ToDo list)?
>
> To work round it for now, can you remove all security from your copy
> of
> the database just whilst you migrate it?

Well, you know that sometimes when you asking question to someone then
the answer comes to our mind? It happened to me now. I figured out that
the database I tried to migrate has AutoExec macro which run
automatically a form. I drop the AutoExec, and successfully migrate it
to PostgreSQL.

However, I have two Access DB which has this AutoExec stuff, and I
still have a problem with the other one. At this point I confused. I
took the same step with the previous one but it still can't be migrated
to PostgreSQL.

> Regards, Dave.
>
Thank you anyway.
--
Ag.B

__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com

> -----Original Message-----
> From: Anung B. Ariwibowo [mailto:barliant@yahoo.com]
> Sent: 13 August 2002 05:07
> To: Dave Page; barliant@duabelas.net; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Migrating mdw'ed MSAccess Database
>
>
>
> --- Dave Page <dpage@vale-housing.co.uk> wrote:
> >
> > > -----Original Message-----
> > > From: Anung B. Ariwibowo [mailto:barliant@yahoo.com]
> > >
> > > I have an MSAccess Database which is created using workgroup
> > > administrator under MSAccess (those *.mdw stuff). I created
> > > this database using MSAccess2000. When migrating this
> > > database to PostgreSQL, I first convert it to Prior Version
> > > of database (MSAccess97),
> >
> > Why do you do this?
>
> converting first to Access97? When I first time tried to
> migrate one of my Access2000, PgAdmin didn't successfully
> migrate it. So I usually convert it to Access97.

Oh. It should handle Access 2000 & XP OK. In fact I test it using the
Access XP versions of biblio.mdb & northwind.mdb.

> > No, you normally don't. Unfortunately I know very little
> about Access
> > security, but could this problem be caused by pgAdmin not using the
> > correct MDW file (this an item on my ToDo list)?
> >
> > To work round it for now, can you remove all security from
> your copy
> > of the database just whilst you migrate it?
>
> Well, you know that sometimes when you asking question to
> someone then the answer comes to our mind? It happened to me
> now.

Happens to me all the time. I guess sorting it out in your mind to write
it down well helps you understand it a little better.

> I figured out that the database I tried to migrate has
> AutoExec macro which run automatically a form. I drop the
> AutoExec, and successfully migrate it to PostgreSQL.
>
> However, I have two Access DB which has this AutoExec stuff,
> and I still have a problem with the other one. At this point
> I confused. I took the same step with the previous one but it
> still can't be migrated to PostgreSQL.

Can you use the Access Export facility to export the tables and their
data to an external mdb file and migrate from there? A colleague & I did
that the other day when the security on an original file got messed up
and we needed to modify the schema. The resultant file contained no
security at all so we could hack t as we pleased.

Regards, Dave