Error Number 3704 Operation Not Allowed Object Closed
Contents |
is closed Page 1 of 1 New Topic/Question Reply 9 Replies - 44529 Views - Last Post: 23 May 2012 - 06:53 AM Rate Topic: #1 doty New D.I.C Head Reputation: 0 Posts: 4 Joined: 18-May 12 Run-time error 3704 run-time error 3704 operation is not allowed when the object is closed operation is not allowed the object is closed Posted 19 May 2012 - 12:59 AM
Runtime Error 3704 Operation Is Not Allowed When The Object Is Closed
Guys i need you help in this error i use vb6 project with orcal DB and when i want to enter admin user operation is not allowed when the object is closed sql name and password he give me this error Run-time error 3704 operation is not allowed the object is closed and when i click Debug he give me this code and the like is Yalow pls i need operation is not allowed when the object is closed error 3704 u help guys Dim cn As adodb.Connection Dim cmd1 As String Dim rs As adodb.Recordset Dim rk As adodb.Recordset Dim i, j As Integer Dim sqlcmd, sqk, strsql, strname, str1, rate, a, b, c As String Private Sub cmdCancel_Click() main1.Show Unload Me End Sub Private Sub cmdOK_Click() Dim flag As Integer flag = 0 [b]If rs.RecordCount <> 0 Then[/b] rs.MoveFirst Do While Not rs.EOF If txtUserName.Text = rs.Fields(0) And txtPassword.Text = rs.Fields(1) Then flag
Run-time Error '3704' Application-defined Or Object-defined Error
= 1 Exit Do Else rs.MoveNext End If Loop If flag = 0 Then MsgBox "INVALID USER" txtUserName.Text = "" txtPassword.Text = "" Else admn.Show Unload Me End If Else MsgBox "NO RECORDS PRESENT !!!!" End If End Sub Private Sub Form_Load() On Error Resume Next cmd1 = "Provider=MSDAORA.1;User ID=scott;password=tiger;Persist Security Info=False" Set cn = New adodb.Connection Set rs = New adodb.Recordset With cn .ConnectionString = cmd1 .CursorLocation = adUseClient .Open End With rs.Open "SELECT * FROM admlog", cn, 2, 3 End Sub Is This A Good Question/Topic? 0 Back to top MultiQuote Quote + Reply Replies To: Run-time error 3704 operation is not allowed the object is closed #2 maj3091 D.I.C Lover Reputation: 327 Posts: 1,945 Joined: 26-March 09 Re: Run-time error 3704 operation is not allowed the object is closed Posted 19 May 2012 - 01:21 AM As a guess, I would say your record set isn't getting populated. Try putting a breakpoint in your form_load and step through the code to check that the connection is opened and/or the recordset is populated. Try adding some "proper" error handling to it as well, On Error Resume Next is going to hide issues. Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply #3 doty New D.I.C Head Reputation: 0 Posts: 4 Joined: 18-May 12 Re: Run-t
360 games PC games runtime error 3704 vba Windows games Windows phone games Entertainment All Entertainment operation is not allowed when the object is closed vb6 Movies & TV Music Business & Education Business Students & educators
Operation Is Not Allowed When The Object Is Closed Vbscript
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://www.dreamincode.net/forums/topic/279878-run-time-error-3704-operation-is-not-allowed-the-object-is-closed/ Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/964444 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
360 games PC games https://support.microsoft.com/en-us/kb/235340 Windows games Windows phone games Entertainment All Entertainment http://visualbasic.ittoolbox.com/groups/technical-functional/visualbasic-l/run-time-error-3704-operation-not-allowed-when-object-is-closed-2714698 Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet not allowed Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All operation is not Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre bracke Locutus PCMag Dennis Stevenson Craig Borysowich DukeGanote Richard mircea_luca iudithm Nikki Klein AbhaiTripathi knowscognosdoi Clinton Jones Iqbalyk bluesguyAZ59 COMPANIES Thawte Oracle CloudLock Epicor Software ... View All Topics View All Members View All Companies Toolbox for IT Topics Visual Basic Groups Ask a New Question Visual Basic – General Discussions The VB - General Discussions group is a forum where peers share technical expertise, solve problems, and discuss issues related to the use of the Visual Basic programming language. Home | Invite Peers | More Visual Basic Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Run time error 3704 .. operation not allowed when object is closed salil kayyum asked Apr 22, 2009 | Replies (6) Dim objConn As New ADODB.Connection 'connection which is initialized globally and the connection is closed on form unload Dim objRs As New ADODB.Recordset 'Global recordset . Closed on form unload Dim CurrentRecID As Integer 'Variable to keep track of which record is currently shown. The Primary key of the table