Question How to programmatically copy table from Access 95 to Access 2003

[StephanieD]

We have an old app that will only read its old Access 95 database.

My copy of Access 2003 will only open the Access 95 database in read-only mode, so I cannot add the fields we need. Also, Access 2003 will not correctly perform an upgrade of the database to 2003 format.

I have written new software that reads the old Access 95 database, but its time to point the new software to a newer version of the database in which we can actually modify fields.

So.... During the transition period, I would like to do a daily conversion of the 95 database to 2003 format, so the new software can point at the newer database, but still be looking at relatively fresh data.

As mentioned above, Access will not do it automatically, so I would be willing to open both the old and the new databases and programmatically copy everything over row by row.

I'm not looking for code, just any suggestions as to the best way to go about this. Is it something that could/should be written in VB within Access?

 

[WayneRyan]

Stephanie,

To make this as easy as possible, I'd suggest that you make a BLANK A2003 database and Import all into it.

Files --> Get External Data --> Import

Then Select All on EACH Tab.

That will hopefully save you any "daily" migration problems.

Surely you'll be able to IMport most of it. If it doesn't I would hope that we can come up with a
viable game plan.

Ignore the "viable game plan" part, it should import.

Wayne

 

[Mike375]

I converted several Access 95s I had to Access 2003 around 2005.

Open in Access 95 and compile. Remove Access 95.

Create blank data base for A2003 and import from the A95 data base.

After doing that all worked except for code I had for opening Word and inserting Access data into Word bookmarks. It did not recognise EditGoTo for the bookmarks and stuck all the Access data at the vert start of the Word doc

I do an Access 97 one each month (it only has tables and some queries) and I do it via import. Conversion is a foul up.

 

[StephanieD]

Thanks guys I will give it a try.........
SD

 

[gemma-the-husky]

or even link to the A95 tables, and run a daily make table query to get it into a A2003 format