Problems with VBA code in Access 2000 database while running under Access 2007 in Windows 7
Posted on 2010-11-17
I am having a problem with an Access database on some new computers. The database was written in Access 2000.
It is located on a network drive. The clients had installed some new computers and contacted me for help when the database wouldn't work.
At first, all computers were getting the same error. Any 'button' on their switchboard triggered the following error:
The expression On Click you entered as the event property setting produced the following error: The expression you entered has a function name that Microsoft Access can't find.
The expression is a VBA function, so I assumed the security was an issue.
I was able to fix the XP computers running Access 2002 and 2003 by setting the Macro Security level to Low. They all work now.
But I have not been able to do figure out anything on the windows 7 computers. I downloaded the files to my own network (this is for a client) and I get the same errors. The files are located on a network drive mapped to N:\
There are actually 2 mdb files. A front end and a back end. All of the tables are in the back end and all of the queries, code, macros, reports are in the front end. They are on the same folder.
I have made the folder a trusted location, I've run Access using XP compatibility mode, logged in as administrator, Run as administrator, removed the password they had on the vba modules.
I added autoexec macro to show if the current project has content enabled and it IS enabled.
I have also tried running the database on my local drives only by mapping N:\ to C:\
So far nothing works. I know it must be something related to the code not being available because the error is the same exact error I received on XP when the Macro Security settings are set to Med or High.
It runs fine from XP computers using Access 2002 and Access 2003.