P
Patrick
I have a database that works fine in 2000 and XP, but not
in 2003. Heres the symptoms.
An initial form comes up allowing you to input first
name, last name, or SSN (or any combination of the
three). This in turns drives a query that used like
conditions on all three fields (in case 1, 2, or all
areblank is doesn't throw off the query). This query is
the record source for a second form that is opened from
the first.
So you type in your search critera, hit the search
button, the second form opens up using a query for its
record source, that query uses likes to filter the data,
the likes come from the search criteria.
The backend tables that the query is searching are from a
SQL server 6.5 database.
In 2000 and XP there is no issue. In 2003 Access appears
to hang. The form shows up, but some of the firelds are
never filled in. Particularly ones that use IIF
statements to join fields together. If you switch out of
it (i.e clicking on another window in the task bar) and
then back in, the form shows correclty. After the first
time you do this, you can do the same thing without
leaving access. So a search (it hangs, says
Calculating... on the bottom) click on another open form,
then click back, and poof like magic the data is there.
Without switching in and out, it appears that the form
never updates itself (I've let it sit for over 5 minutes).
Anyone else experiance this?
in 2003. Heres the symptoms.
An initial form comes up allowing you to input first
name, last name, or SSN (or any combination of the
three). This in turns drives a query that used like
conditions on all three fields (in case 1, 2, or all
areblank is doesn't throw off the query). This query is
the record source for a second form that is opened from
the first.
So you type in your search critera, hit the search
button, the second form opens up using a query for its
record source, that query uses likes to filter the data,
the likes come from the search criteria.
The backend tables that the query is searching are from a
SQL server 6.5 database.
In 2000 and XP there is no issue. In 2003 Access appears
to hang. The form shows up, but some of the firelds are
never filled in. Particularly ones that use IIF
statements to join fields together. If you switch out of
it (i.e clicking on another window in the task bar) and
then back in, the form shows correclty. After the first
time you do this, you can do the same thing without
leaving access. So a search (it hangs, says
Calculating... on the bottom) click on another open form,
then click back, and poof like magic the data is there.
Without switching in and out, it appears that the form
never updates itself (I've let it sit for over 5 minutes).
Anyone else experiance this?