--- Dave Page <[EMAIL PROTECTED]> wrote: > > > -----Original Message----- > > From: Anung B. Ariwibowo [mailto:[EMAIL PROTECTED]] > > > > 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 ---------------------------(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
