OS problem

[sheela]

I have developed a database, which is working fine on
Windows 2000 operating system with ACCESS 2002 and ACCESS
2003.
But the same program is not working on Windows XP using MS
ACCESS 2003.
There are two select querries not working, which take
parameter value. And these querries will be called from a
form.
Could some one tell me what i need to do to make the
database application to work?

Thank you,
sheela.

 

[Allen Browne]

Hi Sheela.

The difference is more likely to be in the versions of JET between the two
machines.

Locate the file msjet40.dll (typically in windows\system32).
Right-click, and choose Properties.
On the Version tab, you should see 4.0.8xxx.

If the release number does not start with an 8, go to
http://support.microsoft.com and in the Downloads section you will find JET
4 SP8. Apply to both machines.


If that does not solve the problem, it is just possible that there is an
inconsistency in the way the parameter is being interpreted. Did you declare
the parameter (Parameter on Query menu in query design view)? For example,
if the parameter refers to a combo box on a form that is bound to an
AutoNumber column, you would enter something like this into the Parameter
dialog:
[Forms]![MyForm]![MyCombo] Long