Error 429 when in Access 2007 (porting from 2003) performing "NewUserWS = DAO.DBEngine.Workspaces(0)"
Posted on 2007-11-25
I used an Access 2003 DB in XP Pro to process some emails that came into Outlook.
Recently upgraded to Vista Ult.and Access 2007. The same database generally seems to work the same way however, a part of the Access DB application creates a new database and since porting to Access 2007 this fails.
I remember having a similar problem before once and I fixed it by chaning the refereince. Therefrom from the code window I went into "referces" and made the code refenrece
"Microsoft DAO 3.51 "
instead of version 3.6 which is what it defaulted to. However, I have made the same change in Access 2007 and it has not fixed it.
The actual part of the code where it fails is:
***Start of code section***
Dim NewUserDB As DAO.Database
Dim NewUserWS As DAO.Workspace
(EROR 429 occurs on this line) Set NewUserWS = DAO.DBEngine.Workspaces(0)
Set NewUserDB = NewUserWS.CreateDatabase(NewUserDBLocation + NewUserDBName, dbLangGeneral, dbEncrypt) '
***End of code section***
Can anyone help with what I have to do to get it working.
I'm considering instaling Access 2003 and going back to it for this appliction, but it would be nice to not have to install Access 2003 on my new Vista PC.
Thanks in advance.