Home > Time Error > How To Solve Runtime Error 3709

How To Solve Runtime Error 3709

Contents

MZTools (free upgrade for the VB6/VBA Editor) Reply With Quote Nov 23rd, 2010,09:22 PM #9 RhinoBull View Profile View Forum Posts PowerPoster Join Date Mar 2004 Location New Amsterdam Posts 24,135 Workaround 2: Run the application always as administrator. How to comment blocks of code in VB5 and VB6 . Register Hereor login if you are already a member E-mail User Name Password Forgot Password? Check This Out

External component has thrown an exception (while generating preview of reports). Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud Thread moved to 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums) There is general advice on various common errors (including this Tutorial: How to automate Excel from VB6 (or VB5/VBA) .. http://www.vbforums.com/showthread.php?633744-Run-time-error-3709-The-connection-cannot-be

Run Time Error 3709 The Connection Cannot Be Used To Perform This Operation

limit.) Question: (Please be specific.) Tags: (Separate with commas.) What is a Tag? the same errors come up<< Exactly. Reply With Quote Quick Navigation Visual Basic 6.0 Programming Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Visual C++ & C++ Programming Visual C++ Programming LVL 49 Overall: Level 49 Visual Basic Classic 24 Message Active today Expert Comment by:Ryan Chong ID: 109081402004-04-24 >>gcnLibrary.Open "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = CoastandCountry.mdb" ??

Understand that English isn't everyone's first language so be lenient of bad spelling and grammar. Privacy Follow Thanks! Filtering Arrays . Run Time Error 3709 Vba Covered by US Patent.

Keep the label (Label6) and the TextBox (txt_StudNo) 'Delete the extra code from The Form and let us test the connection. Runtime Error 3709 Vb6 Register Hereor login if you are already a member E-mail User Name Password Forgot Password? Thanx Rhino Bull, I tried the changes you suggested but am getting an ODBC error. http://relyonsoft.com/techsupport/?p=1662 Microsoft MVP - Visual Basic 2006-2013 Why VB clears the clipboard on startup and how to avoid it? .

Recent CommentsDavid on .NET framework installation did not succeed, error HRESULT 0xc8000222.nancy on .NET framework installation did not succeed, error HRESULT 0xc8000222.Samboy on SQL Server Setup could not connect to the Run Time Error 3709 In Excel Vba Ask Question Free Guide: Managing storage for virtual environments Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well I'm more concern on the 1st one, if 1st one is ok, before the line of your Open statement, output the pstCustomersSQL like: debug.print pstCustomersSQL exit sub '<< quit for debug Application Lifecycle> Running a Business Sales / Marketing Collaboration / Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C / C++ / MFC> ATL / WTL / STL Managed C++/CLI

Runtime Error 3709 Vb6

I have actually run into this! http://www.codeproject.com/Questions/557798/VB-plusrun-timepluserrorplus-plustheplusconnect Can anyone see the problem i have tried re writing the sql to no avail. Run Time Error 3709 The Connection Cannot Be Used To Perform This Operation This l… MS Excel Office 365 MS Access MS Office Visual Basic Classic Advertise Here 720 members asked questions and received personalized solutions in the past 7 days. Run Time Error 3709 Access is both Connection Object?

Results 1 to 3 of 3 Thread: can't open connection (run-time error 3709) Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode his comment is here Privacy Reply Processing your reply... private Sub loadinfo() Dim SQL as string, rs as ADODB.Recordset set rs = new ADODB.Recordset SQL = "SELECT master.CARD_CODE, master.FIRSTNAME, master.LASTNAME, master.TITLE, master.DEPARTMENT, master.MI, master.Course, master.Photograph_File_Name, verification.Dept, verification.Acctg, verification.Reg, verification.DO, verification.LRC, If this is your first visit, be sure to check out the FAQ by clicking the link above. Run-time Error '3709' Requested Operation Requires An Ole Db

You could use something like i have done below.Public adoDatabase As New ADODB.ConnectionDim rst As ADODB.Recordset Private Sub Form_Load()Set rst = New ADODB.Recordsetrst.Open "Reprocess", adoDatabase, adOpenKeyset, adLockOptimistic, adCmdTabletxtMName.Text = rst("ManufacturerName").ValuetxtMSno.Text = FlexGrid: AutoSize columns .. Go to Solution 23 7 3 +2 5 Participants brohjoe(23 comments) Rory Archibald(7 comments) LVL 85 MS Excel85 VB Script21 MS SQL Server 20054 cyberkiwi(3 comments) LVL 58 MS SQL Server this contact form Search IT Knowledge Exchange Join / Login IT Knowledge Exchange a TechTarget Expert Community Questions & Answers Discussions Blogs Tags Welcome to TechTarget's expert community for technology professionals.

E-mail: Submit Your password has been sent to:[email protected] tech target logo About Us Contact Us FAQ Community Blog TechTarget Corporate Site Terms of Use DMCA Policy Privacy Policy Questions & Answers Run Time Error 3709 Visual Basic 6 Great for personal to-do lists, project milestones, team priorities and launch plans. - Combine task lists, docs, spreadsheets, and chat in one - View and edit from mobile/offline - Cut down Thank you guys Il most definately do that Rhinobull, si_the_geek, conn is public and was declared in a module elsewhere.

To start viewing messages, select the forum that you want to visit from the selection below.

Reply With Quote Nov 23rd, 2010,06:42 PM #8 si_the_geek View Profile View Forum Posts Super Moderator Join Date Jul 2002 Location Bristol, UK Posts 38,488 Re: Run-time error '3709' The connection Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Forum New Posts Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders dBforums Data Access, Manipulation & Batch Languages Delphi, C etc can't open connection (run-time The Connection Cannot Be Used To Perform This Operation Vba Terms of Service Layout: fixed | fluid CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100 Search: Advanced Forum Search Forums Programming Web Development Computers Tutorials Snippets

Have a look at the attached. FlexGrid: fill from recordset .. which is meant to take the user to the Customer Form... navigate here SQL Server downloads ..

respond to my next post and ill another 50 points each :) Cheers, Spiz 0 Featured Post A Knowledge Base That Stays Up-to-Date Promoted by Quip, Inc Quip doubles as a We'll let you know when a new response is added. MDAC/Jet/ACE downloads .. Windows have a user interface which might cause a dialog to open and the window closure to be aborted.

As well as at DisplayData Sub-routine in the same form: Sub DisplayData() 'txtcustomerno.Text = mrsCustomers!customerno txtcustomerno.Text = mrsCustomers!CustomerNumber 'txtlastname.Text = Format(mrsCustomers!lastname, "String") txtlastname.Text = Format(mrsCustomers!Surname, "String") txtfirstname.Text = Format(mrsCustomers!firstname, "String") txtstreet.Text Go to menu Project >ProjectName Properties, at the General Tab's Startup Object, select Sub Main, so that your code in Sub Main is First to be executed. All rights reserved. I may not be understanding this statement correctly but I dont see how this could be in my case as Ive used the exact same code in other screens with no

How to comment blocks of code in VB5 and VB6 .