Access '95 to 2007

[dalgo]

I have Access '95 and wish to upgrade to Access 2007 (XP).

Will I be able to convert my database directly, or is there some way I can convert it indirectly. ie by converting it to an earlier version first?

 

[g28dman]

I have Access '95 and wish to upgrade to Access 2007 (XP).

Will I be able to convert my database directly, or is there some way I can convert it indirectly. ie by converting it to an earlier version first?

I searched google for this:
http://technet2.microsoft.com/Offic...ba1c-446a-8ff2-221769a58ba51033.mspx?mfr=true

 

[dalgo]

Thank you, that was helpful. The critical passage is:

Converting a database
Access 97 or earlier format databases are converted into Access 2002-2003 format by default. If a database is converted to Access 2002 or Access 2003, the database can only be opened by Access 2002 or Access 2003. To convert an Access 97 or earlier database to Office Access 2007 ACCDB file format, you must first convert it to Access 2002, Access 2003, or Access 2000. You can then convert the database to Office Access 2007.

This certainly sounds like just what I want, in theory. Has anyone had experience of it in practice? I do not want to purchase 2007 until I am sure it will work. I rang a Microsoft help line and they told me it wasn't possible to do this.

 

[Moniker]

Access 2007 will definitely open Access 2002/2003 files. I think the wording is a little weird, but what it means is that Access 95 will be converted automatically to Access 2002/2003, and then it can no longer be opened by Access 95. There's no reason you can't convert from 95 to 2002/2003, and then from 2002/2003 to 2007, but I don't know what that may affect in the original Access 95, if anything. The data will probably still be intact; instead, I'd imagine it may affect code/queries.

Then again, it's 2007, not 1995, and I haven't used Access 95 in quite some time, so there's no way I can personally test this.

Of course, you can download the trial version from Microsoft and see if it does what you want. Just backup your Access 95 DB first so you don't lose it if it doesn't.

 

[dalgo]

In the unlikely event that anyone else wants to do this I can now report a successful conversion. I bought Access 2007, read in my '95 database and it was promptly converted to 2007 format with no hassles, not even a raised eyebrow. There were a few minor problems:

- an error table was produced which I deleted with no apparant problems
- Because of a difference in the handling of dates I needed to manually change queries that used 'Format ([date]' to Year[date]' etc
- there were a lot of unrelated objects that returned to their correct position when simply opened and closed

 

[Simon_MT]

Whilst I only converted from Access 97 to Access 2007, I did notice that my scripts for Openform and OpenReport needed to revised.

Although this relates to a previous thread if there are performance issues in database with the table there is a property Subdatasheet Name it would seem that this needs to be changed to None.

Simon