R
R. Choate
I have pulled a using ADO, which I need to save to a file. I've done this a million times, but with this recordset, I get Error
2147217887 (8004e21), and it ways "Multi-Step Operation Generated Errors". I looked at the recordset properties and determined that
one of the fields has a defined size of -1. That field is a CHAR type and is numeric. In the table properties, it says that field is
"numeric,5,required". Also, some of the records have less that 5 characters. I can't alter the source database in any way. Whatever
I do, I have to do it after I pull the records. I'm only getting 6 fields, and I haven't done anything to change the data in the
recordset. I know that my connection is good and my recordset is OK, other that what I described. The error comes up at the line of
code where I tell it to save the recordset, as shown below. Please help.
rst.Save "C:\MySubdirectory\MypersistedRecordset.dat", adPersistADTG
Thanks!
2147217887 (8004e21), and it ways "Multi-Step Operation Generated Errors". I looked at the recordset properties and determined that
one of the fields has a defined size of -1. That field is a CHAR type and is numeric. In the table properties, it says that field is
"numeric,5,required". Also, some of the records have less that 5 characters. I can't alter the source database in any way. Whatever
I do, I have to do it after I pull the records. I'm only getting 6 fields, and I haven't done anything to change the data in the
recordset. I know that my connection is good and my recordset is OK, other that what I described. The error comes up at the line of
code where I tell it to save the recordset, as shown below. Please help.
rst.Save "C:\MySubdirectory\MypersistedRecordset.dat", adPersistADTG
Thanks!