Results 1 to 11 of 11
  1. #1
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Wikltshire UK
    Posts
    152
    Thanks
    2
    Thanked 0 Times in 0 Posts

    TransferDatabase to Access 2000 Format (2007)

    HI all,

    I'm creating a database and exporting query created tables from an Access 2007 db using the code below:

    Set db = ws.CreateDatabase(LFilename, dbLangGeneral)
    Sleep 10000
    DoCmd.TransferDatabase acExport, "Microsoft Access", LFilename, acTable, "Docdata", BatchNo, False
    DoCmd.TransferDatabase acExport, "Microsoft Access", LFilename, acTable, "FieldLimiter", "FieldLimiter", False
    db.Close

    The big problem is I need the created DB to be accessable in Access 2000.
    I searched the web and found a suggestion that I should change the "Microsoft DAO 3.6" reference to "Microsoft DAO 3.51" but this dosn't seem to do the trick.

    Any Suggestions???

    Graliv

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

    Re: TransferDatabase to Access 2000 Format (2007)

    If you open the database created by the line

    Set db = ws.CreateDatabase(LFilename, dbLangGeneral)

    which version is mentioned in the title bar?

  3. #3
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Wikltshire UK
    Posts
    152
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: TransferDatabase to Access 2000 Format (2007)

    2007, which is strange because the Database itself is in 2000 Compatability mode?

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

    Re: TransferDatabase to Access 2000 Format (2007)

    Did you specify a filename with extension .mdb? Access 2007 format databases have an extension .accdb.

  5. #5
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Wikltshire UK
    Posts
    152
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: TransferDatabase to Access 2000 Format (2007)

    Yes

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

    Re: TransferDatabase to Access 2000 Format (2007)

    How can an .mdb database be in Access 2007 format? That is a contradiction. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  7. #7
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Wikltshire UK
    Posts
    152
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: TransferDatabase to Access 2000 Format (2007)

    I Agree,bu its TRUE!!!!!!
    Double Checked in Dos to make sure it has the right suffix!! (.mdb)

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

    Re: TransferDatabase to Access 2000 Format (2007)

    I'm not entirely convinced, but what happens if you set the default database format to Access 2000, then run the code?

  9. #9
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: TransferDatabase to Access 2000 Format (2007)

    You should use :
    Set db = ws.CreateDatabase(LFilename, dbLangGeneral,dbVersion30)
    This will create a db in Access 97 format, readable with Access 2000.
    dbVersion40 will create an Access 2002-2003 format.
    I don't see a manner to create an Access 2000 format in the help file.
    Francois

  10. #10
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Wikltshire UK
    Posts
    152
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: TransferDatabase to Access 2000 Format (2007)

    Its already set at 2000??? I know your having to take my word for it, but the observable formats are as stated, however it still does not open. I have noticed that there are Constants within the create DataBase("expression.CreateDatabase(Name, Connect, Option)"): Any suggestions??

    dbEncrypt Creates an encrypted database.
    dbVersion10 Creates a database that uses the Microsoft Jet database engine version 1.0 file format.
    dbVersion11 Creates a database that uses the Microsoft Jet database engine version 1.1 file format.
    dbVersion20 Creates a database that uses the Microsoft Jet database engine version 2.0 file format.
    dbVersion30 Creates a database that uses the Microsoft Jet database engine version 3.0 file format (compatible with version 3.5).
    dbVersion40 Creates a database that uses the Microsoft Jet database engine version 4.0 file format.
    dbVersion120 Creates a database that uses the Microsoft Access database engine version 12.0 file format.

  11. #11
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Wikltshire UK
    Posts
    152
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: TransferDatabase to Access 2000 Format (2007)

    Cheers Fancois, That sorted. I think.

Posting Permissions

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