Migrating mdw'ed MSAccess Database - Mailing list pgadmin-support

From Anung B. Ariwibowo
Subject Migrating mdw'ed MSAccess Database
Date
Msg-id 20020812100911.50108.qmail@web40107.mail.yahoo.com
Whole thread Raw
In response to Cannot see foreign key  ("Purple Skies" <purple_sky@linuxmail.org>)
List pgadmin-support
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), 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?

--
Ag.B


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

pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Cannot see foreign key
Next
From: "Dave Page"
Date:
Subject: Re: Migrating mdw'ed MSAccess Database