Creating Access DB dynamically

[AlanCh]

Hello,
I am trying to create an Access mdb file through my VB application. I am currently using the following two lines of code to do so:

Dim NewDB As Database
Set NewDB = CreateDatabase(dbName,dbLangGeneral,dbVersion40)

Where dbName is the name of the mdb file. This creates the mdb file, however when I try to open the db in MS Access 2000 it tells me that it was created using an earlier version of Access. Although all the data is there and the mdb looks fine, I was just wondering why this message appears.

I am using VB6, SP5 ... does this make a difference? I believe this is the latest service pack.

Also, is this using DAO? If so, how do I create a db using ADO?

Thanks,
Alan

 

[AlexMidd]

This is really a VB question rather than an Access question. I suspect it may be to do with the version of DAO that you are using. In one of your code modules, check Tools..references (or it might be under Project...references, it's a while since I've used VB) and see if there is a more recent version of DAO that you can use. Have fun! )

Alex Middleton