Filter Results are Unpredictable

  • Thread starter Thread starter Jenson
  • Start date Start date
J

Jenson

User is running Access 2000 on his computer and has a
shortcut pointing to a database on a server. The database
is has no linked tables (no separate front and back end
pieces). When the user goes into a form and tries to
filter records, he sometimes will end up with a completely
blank form. Yet, he can walk over to a co-worker's
computer that is linked to the same database, run the same
filter from the same form and the correct record is
returned.

Both users are connected the same way to the same database
on the server. Permissions on the directory where the
database resides are correct. It appears the issue is
isolated to the user's computer. Has anyone else seen
this problem before and does it mean a reinstall of Access
(user's worksite is 30 miles away) or could there be a
simple fix?

Thanks in advance
 
The first thing to look for is whether Access may be misinterpreting the
data type on one computer. This can happen differently if there is any
diffence in service packs, regional settings, etc.

Sources for misinterpreted data types include:
- unbound text boxes: set the Format property to declare the data type;
- calculated fields in query: explicitly typecast, e.g. CVDate();
- incorrectly formatted filter strings;
- any code relying on implicit type casting.

You're a very brave person if you have both these users opening the same
database file at once (which is presumably what's happening if there is no
front end/back end arrangement). Does it make any difference to the problem
if the other user does not log in (and is not logged in from the start of
the session)?
 
Back
Top