Citrix Sever not supporting Access 2003, The expression on Click

You need to get a full copy of Access on the server and look at the references.

 VBA uses a reference list to resolve expressions.   If it goes down the list and finds a broken reference or one that is missing, you will get the errors you are seeing.

 The other issue can be if your using ADO and DAO and have not explicitly typed your objects.  For example, a recordset object exists in both ADO and DAO, but they have different properties and methods.

 If you work on one machine and ADO is listed first in the references, it may work fine.   Move to another which has DAO first, and you will have a problem when you hit an ADO call even though all references are fine.

Jim.

Thank you Jim for the response. This issue very often goes away without doing nothing and comes back again after a couple days? Is there any solution for this?

That is rather odd....can you give more details on the problem in terms of the setup, when this started, old or new problem, anything that might have changed recently, etc?

Jim.

This happen when Administrator moved MS - Access to new version of CITRIX server. It was okay in the previous version. It might not be an issue with the references as it runs well locally. Are there any CITRIX related references to be added?

It might be from the following script

    DocName = "Monthly Schedule"
    DoCmd.OpenReport DocName, A_PREVIEW

Thank you Jim !!!

<<Are there any CITRIX related references to be added?>>

 There is nothing specific to Citrix.  The only difference with Citrix in regards to Access is that everyone is running on the same machine.  So for example, everyone has the same "C" drive.

First, is the application split into a Front end and a backend?  Second, if split, does everyone have their own copy of the front end?  and last, does the front end compile without errors?

<<It might not be an issue with the references as it runs well locally. >>

 Check the reference list when local vs that on the Citrix server.  They may be in a different order.   You do have both ADO and DAO listed, so it's critical that all recordsets be declared explicitly.   Example

Dim rs as ADODB.Recordset
Dim rs2 as DAO.Recordset

If you don't you are going to have problems.

 The other thing I would verify is that all users have security rights for:

1. the directories were the DB's are - They need full rights for the directory.
2. Rights to read the references locations.  You can go down the reference list to get the locations and check if everyone can read and execute them.

 Citrix servers are usually "locked down" security wise and that can be done to the point where things might not work properly for one user, yet work for another.

 I would also double check the servers events logs to see if any errors are being logged that might be related.

Jim.

Hi Jim,

Many thanks for your kind information! I am working on based on your suggestion.

The application is not split into Front end and back end.

There is more thing I need to mention. In the report if we use an expression like =[lastname] & ", " & [Firstname]  it shows  #Name? The query that is supplying data for the report is also working fine.
If I change the expression and just bound textbox to [lastname]  and [Firstname] separately it works.

This does not happen if we access locally.

When network administrator disconnects application users from the CITRIX server and reconnect over again it starts working for a while.
Do you think something wrong with the network or database connection?