I am trying to see if your product will work for me, so I am using the eval version with a membership template directly from Microsoft. In the database these is a calc form that updates the main database automatically (This is how it works locally). After generating the asp pages and passing it up to my webserver to view this is the error message I get:
Error Description: [Microsoft][ODBC Microsoft Access Driver] Field 'Payments.CreditCardNumber' cannot be a zero-length string.
URL: /giftcard/Payments_edit.asp
SQL Query: update [Payments] set [MemberID]=5, [PaymentAmount]=25, [PaymentDate]='1/9/2000', [CreditCardNumber]='', [CardholdersName]='', [CreditCardExpDate]=NULL, [CreditCardAuthorizationNumber]='', [PaymentMethodID]=1 where [PaymentID]=2
Any suggestions?
