Access error in Terminal Server

[Guest 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?

[Guest Ramasamy Pullappan [MSFT]]

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?