I am trying to delete a record from an Access database following the example in Chapter 7 and having a problem with the data types.

The Parameter field that I am trying to use is an "Auto Number" and a Long Integer in Access. The source for the parameter is a Text Box When I try to write the code in VB the pop-up doesn't list a long integer and I can't complete the code. I have tried (without success) several alternatives,

Have you any suggestions?

A Long Integer in Access maps to an Integer data type in the OleDbType enumeration. The maximum value for this data type is 2,147,483,647.

Thearon