Recent content by ADO-Nick

Conclusion Thanks boblarson Can't see the wood for the trees!!:D ADO-Nick

Thanks, ghudsen There is no error number. Exact message is as previous posting. Compile stops on highlighted line. Private Sub ImportData() 'update DB with new input data Dim arNewFiles() As NewFiles 'array of datasets to read Dim intNewFiles As Integer 'number of new datasets to read...

I just created a new subroutine in VB6, as below. I now get a compile time error message: "Statement invalid outside Type Block" Can anyone enlighten me as to why? Private Sub ImportData() code etc. End Sub Thanks for any help, ADO-Nick

Conclusion This problem turned out to be due to needing to specify the .ParentCatalog of the column object BEFORE appending the column! Successful code: With objADOXCol .Attributes = adColNullable .name = pDate .type = adSingle .ParentCatalog = objADOXCat End With...

When should BeginTrans, CommitTrans & RollbackTrans methods be used - always? I'm writing a program that will only ever be used by one user at a time - does this make a difference? Thanks, ADO-Nick

Attached are attributes of the column.

The following is an extract form my programming, using ADO, to store a value - arValues(i) - into a field - Fields(1), having first created a new record in the recordset. objRS.AddNew objRS.Fields("Data_ID").Value = intIndex objRS.Fields(1).Value = arValues(i) objRS.Update The first &...

Hi All, I am trying to set a property defined by MS Access, which applies to an ADO object but isn't recognised by the Jet Database engine. Help that I've found so far suggests that I must: 1) create the property 2) append it to the properties collection 3) then it can be set in the normal...