Access error in Terminal Server

[CCripe]

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?

 

[Ramasamy Pullappan [MSFT]]

Re: Access error in Terminal Server

This looks like more of Access issues. Please try
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?