I have applied MDAC 2.6, now on a WIN95, Win2000 and NT 4.0 all MSAccess 2000 and MSAccess 97 application keep getting VBA errors on sinmple stuff. As an example:
Function is not available in expressions in query expression “000” & trim(str([ColName])) I also get errors on commonly used functions in VBA code also (That one just happened to be in a Query). However if I open the program (Access 2000) and go into VB Editor and say add the DAO 3.6 object library, it then works, until I close it and reopen it. The Library is still checked, but it fails with the same error. Any ideas?
