Dan Waters
dwaters at usinternet.com
Tue Mar 11 20:12:15 CDT 2008
I've come across a problem that seems to be a bug.
With this code:
Dim stg As String
Dim rst As DAO.Recordset
stg = "SELECT * FROM tblTest"
1) Set rst = DBEngine(0)(0).OpenRecordset(stg, dbOpenDynaset, dbReadOnly)
2) Set rst = DBEngine(0)(0).OpenRecordset(stg, dbOpenDynaset, , dbReadOnly)
3) Set rst = DBEngine(0)(0).OpenRecordset(stg, dbOpenDynaset, dbReadOnly,
dbReadOnly)
Line 1 works, as the help file says it should. But putting dbReadOnly into
this position is now obsoleted.
Line 2 does not work, but help says that this is now the correct way to do
it.
Line 3 does work, even though help explicitly says that this will cause an
error.
Anyone have similar experiences or know what is happening?
Thanks!
Dan