Our validation data doesn't admit to 12-digit Visa numbers, but 13-digit Visas are acceptable (for Visa it's 13 or 16 only), as are 13-digit EDC/Maestro and Electron cards.

Another point to bear in mind - credit card numbers can be more than 16 characters long. According to the data we use for validation here, there are at...

This one's all too familiar. in the end we did some googling and found the following (due credit to the original author, James Travis).

All of our databases now have...

Chris,

just to throw another possibility into the ring, we see the "Run-time error 2757 There was a problem accessing the property or method of the OLE object." error with Access...

Seconding Andy's post, our experience (yours may vary of course) of XP_Sendmail inside Triggers included many bad things right up to the SQLserver service terminating unexpectedly.

We moved to having the triggers...

Suzanne,

There are two stages to this - first you need to remove the references to Access Forms from the Stored Procedure itself, replacing them with Input Parameters.  Then, in Access...