LAppling7775
asked on
Read Write Permissions
Is there anything in the code below that would throw a Read/Write Permission error???
rs2 = New ADODB.Recordset
rs2.Open("SELECT * FROM tblFTR_strSQL ORDER BY tblFTR_strSQL.FTRSQL_Seq;" , appAcc, ADODB.CursorTypeEnum.adOpe nForwardOn ly, ADODB.LockTypeEnum.adLockR eadOnly)
Do Until rs2.EOF
currstr = rs2.Fields("FTRSQL_Seq").V alue
rst = New ADODB.Recordset
rst.Open(rs2.Fields("strSQ L").Value, appAcc, ADODB.CursorTypeEnum.adOpe nDynamic, ADODB.LockTypeEnum.adLockP essimistic )
rs2.MoveNext()
Loop
rst.Open(strsql, libAcc, ADODB.CursorTypeEnum.adOpe nDynamic, ADODB.LockTypeEnum.adLockO ptimistic)
libAcc.Close()
strsql = "INSERT INTO [" & TblNm & "] IN '" & libpth & rs2.Fields("LibMdbNm").Val ue & DtStr & ".mdb' SELECT [" & TblNm & "].* FROM [" & TblNm & "];"
rst = New ADODB.Recordset
rst.Open(strsql, appAcc, ADODB.CursorTypeEnum.adOpe nDynamic, ADODB.LockTypeEnum.adLockO ptimistic)
strsql = "Delete * FROM [lib_Ind] WHERE [lib_Ind].FLNM=""" & rsFL.Fields("flnm").Value & """ and [lib_Ind].TblNM=""" & TblNm & """;"
libAcc.Open(libStr)
rst = New ADODB.Recordset
rst.Open(strsql, libAcc, ADODB.CursorTypeEnum.adOpe nDynamic, ADODB.LockTypeEnum.adLockO ptimistic)
libAcc.Close()
rs2 = New ADODB.Recordset
rs2.Open("SELECT * FROM tblFTR_strSQL ORDER BY tblFTR_strSQL.FTRSQL_Seq;"
Do Until rs2.EOF
currstr = rs2.Fields("FTRSQL_Seq").V
rst = New ADODB.Recordset
rst.Open(rs2.Fields("strSQ
rs2.MoveNext()
Loop
rst.Open(strsql, libAcc, ADODB.CursorTypeEnum.adOpe
libAcc.Close()
strsql = "INSERT INTO [" & TblNm & "] IN '" & libpth & rs2.Fields("LibMdbNm").Val
rst = New ADODB.Recordset
rst.Open(strsql, appAcc, ADODB.CursorTypeEnum.adOpe
strsql = "Delete * FROM [lib_Ind] WHERE [lib_Ind].FLNM=""" & rsFL.Fields("flnm").Value & """ and [lib_Ind].TblNM=""" & TblNm & """;"
libAcc.Open(libStr)
rst = New ADODB.Recordset
rst.Open(strsql, libAcc, ADODB.CursorTypeEnum.adOpe
libAcc.Close()
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.