Migration tool Access 2003->2000/SQL Express msch-prv[ at ]bluewin.ch 15.07.2006 07:04:51 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

Re: Migration tool Access 2003->2000/SQL Express "Larry Linson" <bouncer[ at ]localhost.not> 17.07.2006 03:49:38 <msch-prv[ at ]bluewin.ch> wrote > 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. 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