Re: MS Access97 Migration To MS Access2003 and to SQL Server 2000

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rick Sawtell (ricksawtell_at_hotmail.com)
Date: 09/03/04 

Date: Fri, 3 Sep 2004 13:25:31 -0700

A few notes first...

1. I doubt that you will be able to easily upgrade from Access 97 to Access
2003. I have had this nasty job several times and none of them have
upgraded easily.

2. Since the upgrade will not be easy, you may be better off, just porting
your tables to SQL directly and then porting your queries into views or
stored procs in SQL Server.

3. Rebuild your front-end using Access 2003 (I would suggest .NET
instead)..

In the short-term this process will probably take a little bit longer, but
in the long term, it will be far easier for you.

HTH

Rick Sawtell
MCT, MCSD, MCDBA

Relevant Pages

  • Re: ActiveSync stops
    ... I'm using IE7, so it's not directly related to ... that installation itself. ... You can easily upgrade to IE7 final and see if ... I'm now trying to upgrade the ROM on my phone to the latest ...
    (microsoft.public.pocketpc.activesync)
  • Re: Scroll between left and right halves
    ... At home I could easily upgrade but at work we all have 2000 - and I don't ... Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote ...
    (microsoft.public.powerpoint)
  • Re: New Micro ATX mobo reccomendation
    ... Important for a desktop in a real quiet location to be as quiet as it is .. ... connections and you may not be able to easily upgrade the motherboard. ... RAM and the FX570 for $809 and several with dual 320GB drives for just ...
    (comp.cad.solidworks)
  • Re: Open a file
    ... If you did create a .NETCF 1.0 project then you can easily upgrade it ... by right clicking on the project and selecting "Upgrade Project". ...
    (microsoft.public.dotnet.framework.compactframework)