Access Crash Because of Date in RecordSource

  • Thread starter José António Silva
  • Start date
J

José António Silva

Hello,

I need to deploy an Access Application to several computers and I don’t know
what to do with this crash.

I have an Access 2003 Application connected to an SQL Server Database via
ODBC that crashes when a date field is present in a form’s recordsource. If I
remove the date from the WHERE clause I can put any other fields with no
problem.

The recordsource of the form looks like this:

SELECT Guia.* FROM guia WHERE Guia.DtInsercao=#7/28/2004# And
Guia.Validada=True;

NOTE1: When constructing the recordsource I always format the date with VBA
to yyyy-mm-dd. What I show above is the form’s recordsource with the date
format changed by MsAccess.

NOTE2: I don’t suspect from ODBC because I have two computers with the same
version and this problem only occurs in one of them.

NOTE3: I have made a jet debug but nothing is logged, i.e., nothing is sent
to the server.

NOTE4: When Access crashes, I have the following error:
AppName: msaccess.exe AppVer: 11.0.5614.0 AppStamp: 3f3c8e3c
ModName: vbe6.dll ModVer: 6.4.99.69 ModStamp: 3f00a6d9
ModStamp: 3f00a6d9
 
Top