We help IT Professionals succeed at work.

Microsoft Access 2010 Enter Parameter Value WIndows 2008 R2

I have several smaill Access databases loaded onto a 2008 R2 Terminal server.  When a user goes to open the database and click on one of the form it says enter Parameter value.  If I open the same database from a XP machine it opens right up no problems.  Please help thanks in advance.
Comment
Watch Question

BRONZE EXPERT

Commented:
In the absence of any other info regarding the setup, the conclusion would be that when you get the prompt the parameter value is not available -so where is the parameter value coming from?
Michael BaezSystem Engineer

Author

Commented:
I dont get the question I didnt build the database.  If I open the same database from a wiindows XP machine it works perfect.
BRONZE EXPERT

Commented:
The fact that you get a prompt means that Access cannot find the data that it normally uses for that parameter.

What is the recordsource of the form that is giving the prompt?  Post the sql view if it's based on a query.

However the prompt could be coming from a a number of possible sources, so you have to provide more information.  

Michael BaezSystem Engineer

Author

Commented:
Ok it happens randomly so I will post a screen shot when it happens
Michael BaezSystem Engineer

Author

Commented:
Here is the Screen shots.  This does not happen if I access it from a XP machine. Problem-20111103-1320.mht
Does the "XP machine" have Access XP (or any version before A2007) on it? If that is the case, pre-2007 forms did not automatically apply their filters on opening; forms opened in Access 2007+ do apply filters and sorts.  The consequence is that garbage values can lay around in A2003- forms' Filter and OrderBy properties without causing a problem until the same database is opened in A2007+.

On a computer that can have exclusive access to the .mdb, start the database holding down shift. Press F11 to see the objects. Open the offending form in design view. In the properties pane, check the Filter property and the OrderBy property. If you don't see an exact match to Forms!frmMain.CboClient, bear in mind that a filter may contain a query that references that form's control.

If the "XP machine" means WindowsXP with A2007 or higher, please disregard.

Hope this helps,
pT72
Michael BaezSystem Engineer

Author

Commented:
The XP machine has A2007.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.