Hi, how are you?
well, well, well...
you forgot to open Database.
system don't know to use DB file where are from.
You should to use command, "OpenDatabase","Workspace", etc.
: I want to open a DAO Recordset
: Database tempDB;
: Recordset rstbl;
: rstbl = tempDB.OpenRecordset("SELECT Name FROM myTblNames", DAO.RecordsetTypeEnum.dbOpenTable, DAO.RecordsetOptionEnum.dbReadOnly , DAO.LockTypeEnum.dbPessimistic );
: Error is Invalid argument