Search results

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...

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...

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...