Solved

Read Write Permissions

Posted on 2006-06-26
1
230 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
1 Comment
 
LVL 28

Accepted Solution

by:
iboutchkine earned 500 total points
Comment Utility
Check if Access database has read/write permission.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now