Seems to be a common problem.  See:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=139040#bm139268

We switched all our triggers and stored procedures to use the DATEADD(d,DATEDIFF(d,0,[DateVar]),0) function.  Others in this forum have said it is faster. 

Frequently Asked Questions About Microsoft Access Security for Microsoft Access versions 2.0 through 2000

http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fsecfaq.asp

You can hide a lot of stuff including the database window, and turn off all the...

If you are trying to generate a standard trigger for each table, we wrote a VB program that does that. 

It creates a script file to create a DELETE and...

We have been using:

-- sp_grep   v1.0 03/16/1995, v1.1 10/26/1995, 

-- Author:   Andrew Zanevsky, AZ Databases, Inc.

-- E-mail:   zanevsky@azdatabases.com

A co-worker found it at

http://www.sqlservercentral.com/scripts/contributions/1201.asp

It will find a...

To strip the "time component" off a date/time value use: 

DATEADD(d,DATEDIFF(d,0,[DateVar]),0)

It's much faster than CONVERT.  What it actually does is return the date/time value with the time set to 12:00:00 AM. 

Your...

Also look at Steve Jone's articles on Change Contol: 

http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp

We have had sprocs come "undone" but it was always because someone didn't get the good copy onto the master...

I don't know why it happens, but I used to have this problem all the time with a couple of "split" databases where the forms, queries, reports were in a front...

Check out this previous thread on NOT IN vs NOT EXISTS vs LEFT OUTER JOIN.  (read through to the end.)

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=18745&FORUM_ID=8&CAT_ID=1&Forum_Title=T%2DSQL&Topic_Title=Select+Statement+Using+Not+In+and+Null+Values

We had similar problems with NOT IN queries...

We do this so often we finally put a 2nd field ChkDateOnly in the table, and use

CAST(CONVERT(CHAR(10),ChkDate,101) AS DATETIME)

in the insert trigger to load it with a "pure date"  -...