ODBC to SQL Server strange behavior

L

Lp12

Hi All,
I have an Access application thats linked to some SQL tables.
The users are connecting to the application via ODBC connection.
One of the users is trying to run a report and gets no data,while user B
runs the same report with the same parameters and gets full data result.
Any suggestions?
I've tried to remove and re-add the ODBC connection but in vain...
Thanks a lot in advance
 
O

Ofer

Some of the things might sound silly so sorry in advance.
I would check few things:
1. Check if both users work on the same MDB, if they are linked to the same
DataBase
2. In the ODBC connection, check the "change default database to:" if it set
the same
3. Does the filter include a date field, check in both computers if the date
format defined the same
4. Check the permissions on all tables that are joined in that query, it
could be that the user has no permission on it
 
L

Lp12

Thanks Ofer,
The date change in the regional setting did the trick.
Can i validate this from Access? and message the user accordingly
Thanks again
 
O

Ofer

Not that I know of
In the organization where I work, we control this settings, so all users get
the same settings when the computer is loaded.
It's worth while starting a new post asking this question, mybe somebody
else has an answer.

Good luck
 
Top