A tip posted on one of the forums about cleaning up and reducing the size of your database file, suggested creating a new (blank) database, and importing all the objects from the application being developed. The import worked fine without errors and the new file is a third the size of the old file, and all the tables, forms, and modules look to be there OK. But the new database now runs with errors.
One of my modules has a routine:
Public Sub ClearFilename()
On Error GoTo Err_ClearFilename
Dim dbsDBS As Database
Dim rstASCII As Recordset
Set dbsDBS = CurrentDb....
which runs fine in the old database, but now when it gets to the "Dim dbsDBS As Database" line, I get a "User-defined type not defined" error. I get the error both when trying to run and trying to compile, and repair\compact doesn't remove the error.
What did I miss? Why did this pop up and how do I fix?
Thanks in advance.
One of my modules has a routine:
Public Sub ClearFilename()
On Error GoTo Err_ClearFilename
Dim dbsDBS As Database
Dim rstASCII As Recordset
Set dbsDBS = CurrentDb....
which runs fine in the old database, but now when it gets to the "Dim dbsDBS As Database" line, I get a "User-defined type not defined" error. I get the error both when trying to run and trying to compile, and repair\compact doesn't remove the error.
What did I miss? Why did this pop up and how do I fix?
Thanks in advance.