8 replies
by quahsays
1. Office97 may not work properly on W2k.
2. A particular function used in Access 97 is not supported in latest version of the ocx.
MS is not going to support Office97 pretty soon,...either
1. run only on Win9x
2. upgrade office
Is the error message occurred when you run the program or when you open the Access database?
by ahall
by stefano
by ahall
Windows 2000 Service Pack 2 addressed a lot of those types of compatibility issues. Install SP2.
Maxwell
.
.
If you have SP2 installed, or after you install it you get the same error, consider this:
According to Microsoft article Q194374 titled, "ACC97: Error Message: Function Isn't Available in Expressions in Query Expression"
CAUSE:
You developed a database by using a particular version of a type library, and then upgraded the version of the type library on your development computer.
-or-
You referenced a type library on your development computer, and then moved the database to a computer that has a newer version of the type library.
NOTE : This issue often involves references to Comctl32.ocx. But this issue can also occur with other type libraries. An example of installing a newer type library version is installing newer versions of Microsoft Data Access Components (MDAC). Sometimes the upgrade of a type library is subtle, such as when you upgrade the operating system version or install a new application.
See this link for the whole article and Microsoft's suggested resolution:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q194374
(REMOVE SPACES from the pasted URL.)
Good luck,
Maxwell
by ahall
by ahall
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending