I am having trouble converting from Jet to odbc. I can only open a recordset
that is read only. The database is opended and updateable = true. However,
no matter how I try to open a recordset, it's read only. What am I doing
wrong? Thanks in advance

    cMdb = "DATABASE = YE;"
    cUID = "UID=;"
    cDSN = "DSN=MS Access 7.0 Database;"
    cDBQ = "DBQ=" & App.Path & "\YE.MDB;"
    cPWD = "PWD=;"
    sCONNECT = "ODBC;" & cMdb & cUID & cPWD & cDSN & cDBQ

    On Error GoTo open_err
    Set Form2.GlbWrkODBC = CreateWorkspace("", "", "", dbUseODBC)
    Set conYe = Form2.GlbWrkODBC.OpenConnection("", False, False, sCONNECT)

    Set Form2.gblYeMdb = conYe.Database

  in another module.....

sqlSched = "select * from " & strTableName & ";"
strTableName = "sched_D2"

    Set rsSched = Form2.gblYeMdb.OpenRecordset(sqlSched, dbOpenDynamic,
False)

    Set rsSched2 = Form2.gblYeMdb.OpenRecordset(strTableName, dbOpenDynaset,
False)

neither sets work!!!!

Try:

Set rsSched2 = Form2.gblYeMdb.OpenRecordset(strTableName, dbOpenDynaset,
,dbOptimistic)

or just:

Set rsSched2 = Form2.gblYeMdb.OpenRecordset(strTableName, dbOpenDynaset)

Why did you put false for the options parameter?

--
Matthew Arnheiter
Flash Creative Management
http://www.flashcreative.com

Set Mode: Read/write in the connection string

Hope this help!

--
Khalid S. Al-Khater

www.khalidalkhater.net