Web Development

Ask something
Discussion Locked

MDAC 2.6 and MSAccess 2000

0 helpful
3 replies

by fofa 2 views

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

3 replies

by donq

When the Database Window is open click Tools on the menu. Then click ActiveX Controls... and check the DAO3.6 DLL and it will load whenever Access starts.

This discussion is closed to new replies.