Recent content by Rob601

I know it's possible, however unwieldy, to compact and repair a database in code, but I'm looking for a way to reset an autonumber counter and continue running code. Compact and repair won't work because it closes the database. Is there another way to reset the autonumber counter besides...

Okay, actually I figured it out. Since I'm using SQL anyway, the following method works: With CurrentDb .Execute "DROP INDEX PrimaryKey ON myTable;" .Execute "DROP INDEX RecID ON myTable;" .Execute "ALTER TABLE myTable DROP COLUMN RecID;" .Execute "ALTER...

I'm trying to assign an autonumber primary key and every resource I find uses the following approach to set the autonumber: CurrentDb.TableDefs("myTable").Fields("RecID").Attributes = dbAutoIncrField But I'm getting run-time error 3219 Invalid Operation. I have the DAO 3.6 object library...

Thanks for the help, but the problem is I didn't want to have to set the reference to the DAO library, because all the other recordsets I'm using in the code are ADO and I want to keep everything consistent if I can. I didn't know Access uses DAO recordsets for forms - that's kind of a pain. I...

I'm trying to create a recordset equal to a subform's recordset using ADO. I can do it with DAO: Dim rs As DAO.Recordset Set rs = theSubform.Form.Recordset but this won't work with an ADO recordset. I can open an ADO recordset using the subform recordsource in the Open method: Dim...