Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2004
    Thanked 0 Times in 0 Posts

    Upgrading from 97 to 2003 (2003)

    The option to upgrade from 97 to 2003 is available to me. Are there a) any known conversion issues and [img]/forums/images/smilies/cool.gif[/img] any major bugs with the 2003 software?

    Thanks, Steve

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Upgrading from 97 to 2003 (2003)

    Welcome to Woody's Lounge!

    If you do a search in this forum for convert 97, you'll find numerous older threads dealing with the conversion from Access 97 to Access 2000/2002/2003. Some things to look for:
    <UL><LI>Make implicit DAO declarations explicit (Dim rst As DAO.Recordset instead of ... As Recordset). Starting with Access 2000, there is a new data object model, ADO, while the original object model, DAO, still exists. Both contain a Recordset object, so it is important to avoid confusion.
    <LI>Bracket query parameters ([Forms]![frmSomething]![txtStart] instead of Forms!frmSomething![txtStart])
    <LI>Modify code for formatted MsgBox (using @ in the prompt text doesn't work any more)
    <LI>Recent versions of Access have more restrictions on when a query based on more than one table is updatable. Make sure that there is a unique index on the "one" side of a join.
    <LI>Merging data to a Word document has changed drastically in Office 2002.
    <LI>The use of Unicode causes some characters to be displayed differently.[/list]As with all versions, Access 2003 has bugs. Many bugs that existed in the original release have been fixed in the recently issued Service Pack 1, but no doubt there are others.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts