Guest CCripe Posted October 15, 2008 Posted October 15, 2008 In an Access 2003 database, there is a macro that captures the user's environ name and inserts it in a field. To make this work, the user must go into Macro=>Security and set the security level to low. This works fine everywhere but TS. If you set the macro security to low on TS, the function works for a day or so, then it stops working and you get this error: "The expression you entered has a function name that (database name) can't find." If they go in and tell it AGAIN to set the macro security to low in Access, it will work for awhile and then stops. It doesn't seem to matter what rights the person has; Administrator, Power User, etc. All get the error message. Any ideas?
Guest Ramasamy Pullappan [MSFT] Posted October 21, 2008 Posted October 21, 2008 Re: Access error in Terminal Server This looks like more of Access issues. Please try http://news://msnews.microsoft.com/microsoft.public.access -- This posting is provided "AS IS" with no warranties, and confers no rights. "CCripe" <CCripe@discussions.microsoft.com> wrote in message news:05896F2A-2645-4370-AE3A-37D4DAE3FDA2@microsoft.com... > In an Access 2003 database, there is a macro that captures the user's > environ > name and inserts it in a field. To make this work, the user must go into > Macro=>Security and set the security level to low. This works fine > everywhere but TS. If you set the macro security to low on TS, the > function > works for a day or so, then it stops working and you get this error: "The > expression you entered has a function name that (database name) can't > find." > If they go in and tell it AGAIN to set the macro security to low in > Access, > it will work for awhile and then stops. > > It doesn't seem to matter what rights the person has; Administrator, Power > User, etc. All get the error message. > > Any ideas?
Recommended Posts