Shift-F2 causes Invalid use of Null error

[svines]

Here's the setup:

- Access MDE application on Win2000 server running Terminal Services. Access Run-Time 2002 is installed on the server.

- Users on WinXP/2000 connect via Remote Desktop, and are set to run the MDE automatically (therefore restricting running any other application).

Here's the problem:

Users can open the database no problem, but as soon as they hit Shift-F2 to zoom on any text field, they get the Invalid use of Null error message. I've narrowed it down to the fact that I've set the application in the terminal services startup parameters (when I remove that and run the application manually, it works no problem).

Searching around on the net showed me that the Zoom form is found in the Utility.mda file in the Access program folder. I'm assuming the error is caused by the fact that utility.mda can't open (restricted in terminal services profile).

How can I get around this without having to create a custom form to replace Microsoft's zoom form in utility.mda?

 

[judgehopkins]

You did not say, but I assume you are using A97. If so, there is a patch which may solve your problem:

http://support.microsoft.com/defaul...port/kb/articles/Q179/6/95.asp&NoWebContent=1

http://support.microsoft.com/default.aspx?scid=kb;EN-US;151261

[red]I do not have A97 and have not tried out this patch...backup before you try![/red]

"The potentialities of a language are so vast that we must wonder sometimes at ourselves: how do we manage to know so much?" Anthony Burgess, A Mouthful of Air

 

[svines]

I'm not using 97, I'm using Access Run-Time 2002.

 

[judgehopkins]

http://support.microsoft.com/default.aspx?scid=kb;en-us;283849

What is the error number you are returning?

BTW, if you have not compacted and repaired the db, read the above article.

Also, read thread709-433483 and

http://www.microsoft.com/officedev/tips/nullzero.htm

on that particular error message.

I suspect somewhere you are referencing a null that is causing this error; the only way around it (if that is true) is to fix the programming.

Sorry I couldn't help; if I knew the answer I would tell you!

"The potentialities of a language are so vast that we must wonder sometimes at ourselves: how do we manage to know so much?" Anthony Burgess, A Mouthful of Air