I'm using a page to connect to a database and add data to the tables. Some of the fields on my form, and not always the same ones, produce the following error upon submission:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/spfldclinicscripts/InternalCombined.asp, line 183
Here's my connection string:
set adoCon = server.createobject("adodb.connection")
set rs = server.createobject("adodb.recordset")
sSQL = "SELECT * FROM Internal"
adoCon.open "DRIVER=Microsoft Access Driver (*.mdb);DBQ=C:\spfldclinicscripts\scdata\db\InternalApplicants.mdb"
rs.open sSQL, adoCon, 1, 3, 1
I use the same connection string with a different database and don't receive this error. All fields in the database are set to text fields, and text is what is being collected on the form and is attempting to write to the database.
Any suggestions are greatly appreciated!!