Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Read Write Permissions

Posted on 2006-06-26
1
Medium Priority
?
252 Views
Last Modified: 2008-02-01
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.adOpenForwardOnly, ADODB.LockTypeEnum.adLockReadOnly)
                    Do Until rs2.EOF
                        currstr = rs2.Fields("FTRSQL_Seq").Value
                        rst = New ADODB.Recordset
                        rst.Open(rs2.Fields("strSQL").Value, appAcc, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockPessimistic)
                        rs2.MoveNext()
                    Loop

rst.Open(strsql, libAcc, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
                        libAcc.Close()
                        strsql = "INSERT INTO [" & TblNm & "] IN '" & libpth & rs2.Fields("LibMdbNm").Value & DtStr & ".mdb' SELECT [" & TblNm & "].* FROM [" & TblNm & "];"
                        rst = New ADODB.Recordset
                        rst.Open(strsql, appAcc, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
                        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.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
                        libAcc.Close()

0
Comment
Question by:LAppling7775
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 28

Accepted Solution

by:
iboutchkine earned 2000 total points
ID: 16991379
Check if Access database has read/write permission.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question