Hi Didier, It sounds like you are trying to migrate your database using an ODBC datasource. Try using the native Access option.
Regards, Dave. > -----Original Message----- > From: Didier Moens [mailto:[EMAIL PROTECTED]] > Sent: 05 February 2002 16:45 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Migration Wizrd : Foreign keys not > supported !? > > > > Dear all, > > Having successfully used the pgAdminII "Migration Wizard" > last month to > migrate an MSAccess2000 test database, I am since last week trying to > migrate an update of this database. > > Currently, I'm stuck : when entering the "Foreign Keys" tab the > Migration Wizard reports an error "Foreign keys are not supported by > this provider" ; afterwards, the migration fails. > > My MSAccess database is not corrupt ; I checked my relationships. > > > PostgreSQL 7.2rc2 > ODBC 7.1.9 > pgAdmin II 1.2.0 > > Provider (from the connection string) : "MSDASQL.1". > > Could this be due to an update to MSDAC 2.7 ? > > > > > Kind regards, > > > Didier Moens (getting quite desperate) > ----- > RUG/VIB - Dept. Molecular Biomedical Research - Core IT > tel ++32(9)2645309 fax ++32(9)2645348 > http://www.dmb.rug.ac.be > > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an > appropriate subscribe-nomail command to > [EMAIL PROTECTED] so that your message can get through > to the mailing list cleanly >
