I maintain a MS Access 2003 application for a client. The front end sits in a shared directory on their network and they use a bat file to copy the mdb file locally and execute it in the Access Runtime (ART). The back end is MS SQL Express 2005. They just recently tried to install it on their first Vista machine and they encountered an error: Error #3075: Function is not available in expressions. This error occurred on many but not all of the calls back to the database. It obviously had something to do with the references. Upon comparing the references between the same app running on Win Server 2003 and Vista, I found that all of the references were the same except:

Vista: Microsoft ADO Ext. 6.0 for DDL and Security (WDAC 6.0)

Win Server 2003/XP: Microsoft ADO Ext. 2.8 for DDL and Security (MDAC 2.8)

In Vista, they replaced the MDAC 2.8 (Microsoft Data Access Components) with WDAC 6.0 (Windows Data Access Components). These components include ADO, OLE, DB and ODBC. 

I really didn’t feel like messing with rolling back to MDAC 2.8 or trying to make both versions run on the same machine. So, I just tried reordering the references. I moved WDAC 6.0 up as far as I could – second from the top and viola – no errors!

I moved the last reference (not the highlighted one) up to second from the top.

So, if the app is runing in the Access Runtime, how did I get to the VB References?? Well, this particular machine had the full version of Access installed on it. I have no clue what I am going to do when it is only running the Access Runtime. I guess I will have to amend this post…