How to programatically convert access 2.0 database to access 2000/2003

[amudhan]

yes I have written a utility which will do this. but one small thing which I couldn't achieve is that of copying forms, reports and MACROs.. some one had suggested to use access runtime to achieve this. I am just exploring this option..

 

[KenHigg]

Hum... Seem you're pretty determined on this one...

What about if you did a new db and gave it to the user, then programmatically attached to the old data table and import them?

 

[amudhan]

How can I do this? can you give me some code samples.

 

[KenHigg]

Hum...

1. Create a folder in your root directory called something like tempDB.
2. Put a copy of the old db containing the tables in the folder
3. In the new db, attach to these tables.
4. Do regular append query routines to bring the old data into the new tables
5. Send your user the new db
6. Instruct them to do steps 1 & 2.
7. When they run the push button stuff you created in step 4, they should be good to go...

 

[praveen_pc]

help required....... urgently(ASAP)

Hi Amudhan,
Actually i saw ur post , i have also the same problem what ur facing now. I also want to convert programatically the access 2.0 version DB to access 97 or 2003 DB.So please can u send me ur code if possible. Its really urgent.

 

[Mike375]

I converted several Access 95s to 2003 and I think 95 is the one after Access 2......A95 came when Windows 95 came.

The first thing I did (while still in Access 95) was to compile.

I created blank data bases in 2003 and then imported the A95.

Everything worked for me except a lot of code I use for putting Access into Word bookmarks.

As a side note I found A95 much more compatible with A2000 than I did with A97. Some small DBs I had made in A95 would just convert to A2000 and were trouble free but not so with A97. Although none of those DBs had any code they were all macros.

I have never used Access 2 except for importing tables from it into A95.

 

[praveen_pc]

How to Convert Access 2.0 DB to Access 97 or Oracle DB.

Hi Mike,

No no no sorry mike actually am a java developer, and i have a Access 2.0 version data base , Now the problem is i need to convert it to a Oracle DB or else atleast a access 97 or higher except 2007 PROGRAMATICALLY. So can u please help me with the same if possible.

 

[georgedwilkinson]

Why not just use Oracle's upsizing tool?

You'll probably have problems with data types if you do it all on your own and I think Oracle already figured all those issues out and put it into their tools.