I have an Access database I built over a period of years. I started the database in Access 2.0 and continue to build the database in Access 2003.
I retired the database almost twenty years ago, but recently I decided to convert it to a more recent version of Access so I can use it again.
I had a copy of Access 2007 which I installed and used to convert the database from mdb format to accdb format.
And I am getting errors that I never got before the conversion.
One problem I've isolated in a function occurs when the line "Set GetPerDb = DBEngine.Workspaces(0).Databases(0)" tries to execute, it generates "Error 13 - Type Mismatch" in the following part of the function:
Dim GetPerDb As Database
Dim PersonSet As Recordset
Set GetPerDb = DBEngine.Workspaces(0).Databases(0)
I tried substituting the following line, "Set GetPerDb = CurrentDb()" but that only gives the same Error 13.
Does anyone have any idea what might be causing this?
When I open the unconverted, mdb, version of the same database in Access 2007, the same line executes without an error.