Re: Create an Access 2000 format database using DAO?

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

If I recall correctly, at the low level, Access 2000 and Access 2002/2003 are actually the same database format. So if you create a Version40 database through code, the identifiers as to whether it's 2000 or 2002/3 will only be added when you open that database up through the GUI and they're added by Access itself (as opposed to DAO). So at that point, as Alex indicated, it's controlled by the setting in your preferences.

I'm a little rusty, so I might be wrong, but I'm pretty sure that's how it works.


Rob

Cory J. Laidlaw wrote:
Hi,

I've tried the following line of code:

Set tdb = DBEngine.Workspaces(0).CreateDatabase(TargetPath, dbLangGeneral, dbVersion30)

it creates an access 97 version of the database. This line of code:

Set tdb = DBEngine.Workspaces(0).CreateDatabase(TargetPath, dbLangGeneral, dbVersion40)

Creates an access 2002-2003 version.

Does anyone know how to create an Access 2000 Version?
Many Thanks!!

Cory
.

Relevant Pages

  • Re: Create an Access 2000 format database using DAO?
    ... If they are the same format, why in access 2003 is there a tool(database ... database, the tool converts a database up to 2002-03? ... Set tdb = DBEngine.Workspaces.CreateDatabase(TargetPath, dbLangGeneral, ...
    (microsoft.public.access.modulesdaovba)
  • Re: CreateDatabase / Access 2007
    ... adding the dbVersion30 option and then clicking "Compile and Save ... Doug Steele, Microsoft Access MVP ... I converted the Utility database to Access version 2000 and successfully ... Microsoft Access 8.0 Object Library ...
    (microsoft.public.access.modulesdaovba)
  • Re: CreateDatabase / Access 2007
    ... specifying dbVersion30 in the Access 97 version. ... Doug Steele, Microsoft Access MVP ... I opened the 97 version of the Utility database and added "vbVersion30" as ... Microsoft Access 8.0 Object Library ...
    (microsoft.public.access.modulesdaovba)
  • Re: CreateDatabase / Access 2007
    ... but that wasn't a problem -- we've got plenty of computers in the office ... specifying dbVersion30 in the Access 97 version. ... I converted the Utility database to Access version 2000 and successfully ... Microsoft Access 8.0 Object Library ...
    (microsoft.public.access.modulesdaovba)
  • Re: CreateDatabase / Access 2007
    ... although the documentation says dbVersion30 uses database engine ... Doug Steele, Microsoft Access MVP ... (no e-mails, please!) ... Since I do design work using Access '97, would dbVersion30 work just as ...
    (microsoft.public.access.modulesdaovba)