DAO Error

[Rachel]

Hi,
When I open up my access database I get this error.

Error1:
The database was created in an earlier version of
Microsoft Access. To convert the database to the current
version of Microsoft Access, close the database, point to
DB Utilities on the Tools menu and then click convert
database.

After I do this, I then receive this error.

" Microsoft Access
There were compilation errors during conversion or
enabling of this database. This might be due to old DAO
syntax that is no longer supported. For an example on how
to fixup the code, click HELP."

Your help is appreciated.

Thanks,
Rachel

 

[Joan Wild]

After I do this, I then receive this error.

" Microsoft Access
There were compilation errors during conversion or
enabling of this database. This might be due to old DAO
syntax that is no longer supported. For an example on how
to fixup the code, click HELP."

Go into any module (or just hit Ctrl-G). Go to Tools, References and look
at the references that are checked.

If any are marked missing, uncheck them. Ensure that DAO 3.6 library is
checked.

Then go to Debug, and click on Compile, then click on the save button.

 

[Rachel]

Hi,
I followed your instructions but I receive the same error
after making the changes.
There were no references missing but compiling the program
raised an error. strdate.date
I changed the code to datetime and then it compiled
without any problems.
But then I was unable to save. Access told me that I would
basically have to convert the database first and then I
could make changes to it.
So I converted, changed the code and recompiled and
received no errors.
After this, I tried running the reports and they all show
up as errors.

Any other ideas?

Thanks,
Rachel

 

[Joan Wild]

What version of Access are you converting from and to? I expected you to
convert and then follow the steps.

What references do you have checked?

 

[Rachel]

Hi,
I am converting to Access 2000.
Here is the list of references selected.

Visual Basic For Applications
Microsoft Access 9.0 Object Library
Ole Automation
utility
Microsoft Visual Basic or Applications Extensibility 5.3
Microsoft DAO 3.6 Object Library

Rachel

 

[Joan Wild]

You should be able to uncheck the utility one.

Then go to Debug, Compile. If you get any errors, you'll need to fix them.
If it compiles, then hit the save button. Close the window and then go to
Tools, Database Utilities, Compact.

 

[bob]

Hi,
When I open up my access database I get this error.

Error1:
The database was created in an earlier version of
Microsoft Access. To convert the database to the current
version of Microsoft Access, close the database, point to
DB Utilities on the Tools menu and then click convert
database.

After I do this, I then receive this error.

" Microsoft Access
There were compilation errors during conversion or
enabling of this database. This might be due to old DAO
syntax that is no longer supported. For an example on how
to fixup the code, click HELP."

Your help is appreciated.

Thanks,
Rachel