Migration tool Access 2003->2000/SQL Express

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

msch-prv@bluewin.ch - 15 Jul 2006 08:04 GMT

I am looking for a utility that would allow migrating a 2003 BE db back
to 2000 format for editing. (The db acts as a table web container.) I
don't want to upgrade at present: Office 2K serves me quite well!

The db only contains data, no stored procedures.

Question: Is there a tool on the market to do the migration?
Alternatively, is there a utility out there that supports migrating a
2003 db to SQL Express? My understanding is that this can only be done
natively ie. you need Access 2003 to convert a db back to A2k or
towards MS SQL.

TIA, Mark

Reply to this Message

Larry Linson - 17 Jul 2006 04:49 GMT

> I am looking for a utility that would
> allow migrating a 2003 BE db back
[quoted text clipped - 13 lines]
> need Access 2003 to convert a db back to
> A2k or towards MS SQL.

As far as I know, you will need to use Access 2003 or 2002 to save an Access
2002-2003 file format back to Access 2000. Interestingly, both Access 2002
and 2003, by default, save databases in Access 2000 file format, so to get a
database in 2002-2003 format, someone had to change the Options.

If the database uses no features of Access 2002-2003 that are not supported
by Access 2000, it is a very easy conversion, and it is likely that a
data-tables-only database does not use any unique features of Access
2002-2003. If you know a colleague or friend who has Access 2002 or 2003,
perhaps they could do the conversion for you.

I have not heard of an upsizer that specifically targets SQL Express. I
believe an upsizer targeting SQL Server 2005 is either in beta or has
recently been released, however.

Larry Linson
Microsoft Access MVP

Reply to this Message