CDaoDatabase Create Field

[DKScherpy]

Ok, I have a concurrency problem (I think) while trying to create a field using CDaoDatabase & CDaoRecordset. Long and short of it is that I need to create a field in an access database while still keeping a recordset that is connected to the table open. When I create the field using the following code: CDaoTableDef tableDef(&m_daoDB); tableDef.Open(sTableName); tableDef.CreateField(newField); I also have a recordset open on the same table. The last line throws an exception with a message: _The database engine could not lock table 'Test Datatypes' because it is already in use by another person or process._ Any help or thoughts on that would be wonderful. Thanks in advance.