Queries in MS Access 2002 with date field in where clause

G

Guruprasad Samant

Dear All,

I've observed the following in few Win2K or Windows XP
machines. These machines are installed with MS Access
2002. The MS Access client is setup to query on MSSQL
database. The execution of query with a date field in
where clause doesn't work on few of these machines.

The error window pops up with title as "Microsoft Access
has encountered a problem and needs to close. We are
sorry for the inconvenience."

What can be the reason?

For the same OS/Client/DB Server combination the same
query works in few other machines.

I've installed both the SP1 and SP2 of MS Office XP on
these machines.

Rgds,
Guru
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
DateDiff function throwing error in Where clause 6
query to show where no data in a stated column 0
Single WHERE and ORDER clause in UNION? 4
IN Clause Question 1
If statement in Where Clause of SQL? 1
queries written inside MS-Access are getting deleted 4
...cannot use a calculated field in a Where clause... 2

Top