CreateDatabase

[robertf670]

I have an Access database application with a form that has a series of
commands to create a database and copy the existing tables into the new
database. One line of a sub looks like this: Set dbNew =
wrkDefault.CreateDatabase((strNewDbName), dbLangGeneral, dbEncrypt).

Using Access 2003 everything works fine. When attempting this in Access 2007
however, I get an 'Invalid Argument' error. I tried removing the dbEncrypt
argument and it worked, as did the next step of using the TransferDatabase
method to copy the tables into the new database. Is there a way to use the
dbEncrypt option with Access 2007? I'm not sure what is different about it in
the two versions of the program. Thanks in advance for any assistance.

Bob

 

[david]

I haven't got 2007 to try, but I imagine that the default database
format might be different. What kind of database are you trying
to create? Does it work if you try
dbEncrypt + dbVersion40
(david)

 

[robertf670]

That seems to work. Thanks.

I haven't got 2007 to try, but I imagine that the default database
format might be different. What kind of database are you trying
to create? Does it work if you try
dbEncrypt + dbVersion40
(david)