Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Oct 2001
    Canberra, Australian Capital Territory, Australia
    Thanked 0 Times in 0 Posts

    Converting databases (Access 2003)

    Hello Access Gurus,

    I am wondering if there is any information available on converting databases from 97 through to 2003. Do you need to convert a 97 database through all version to get it to Access 2003? or can you just convert from Access 2003.

    Looking forward to your response.



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

    Re: Converting databases (Access 2003)

    You can convert directly to the format you want to use, but that need not be 2003 format. Many users with Access 2002 still use Access 2000 format beacuase that is still the most widely used format. Access 2002 and 2003 can use a database in Access 2000 format without conversion. You can also open an Access 97 database without converting it, but then you won't be able to modify the design (data can still be edited.)

    It might be a good idea to check all VBA code for declarations such as

    Dim rst As Recordset
    Dim fld As Field

    I recommend prefixing those declarations with DAO. to avoid confusion with ADODB, the default data model in Access 2000 and up:

    Dim rst As DAO.Recordset
    Dim fld As DAO.Field

Posting Permissions

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