Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    CreateDatabase method (A2003)

    Is it possible to create a 2003-format file using the CreateDatabase method? So far, I have only been able to create a 2000-format file using this command:

    CreateDatabase sName, dbLangGeneral, dbVersion40
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: CreateDatabase method (A2003)

    No, the DAO CreateDatabase method creates a plain Jet 4.0 database. It only becomes an Access database (with all the extra stuff) the first time you open it in Access.

    To create an Access 2002/2003 format database (which I don't recommend, by the way) in code, you'd have to create another instance of Access using Automation, set the default database type to Access 2002/2003 format and use the NewCurrentDatabase method. You cannot do that from the instance of Access running the code, because code execution would end the moment you created a new current database.

Posting Permissions

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