Access Macro Error 3709
Contents |
One games Xbox 360 games PC error 3709 access 2010 games Windows games Windows phone games Entertainment All ms access error 3709 Entertainment Movies & TV Music Business & Education Business Students & access error 3709 isam seek educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security error 3709 the search key was not found Internet 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 Band Microsoft
Error 3709 The Connection Cannot Be Used
Lumia All 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
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn
Run Time Error 3709 The Connection Cannot Be Used
more about Stack Overflow the company Business Learn more about hiring developers or posting access macro error 2950 ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack access macro error 2001 Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error 3709 in VBA/macros up vote 1 down vote favorite A https://support.microsoft.com/en-us/kb/302525 runtime error of 3709 keeps popping up when I run this part of the program. Does anyone know what I can do to fix it? Public cn As New ADODB.Connection Public rs As New ADODB.Recordset Public CustomerID As Integer Public CustFirstName As String Public CustLastName As String Sub GetCustomerList() Dim strSQL As String Dim Customers As Variant ' Import customer info and use it to populate the list http://stackoverflow.com/questions/1811490/error-3709-in-vba-macros box. ' After frmcustomers is unloaded, we will know the CustomerID ' and Customer Name of the selected order. strSQL = "SELECT CustomerID, CustFirstName, CustLastName FROM Customers" rs.Open strSQL, cn frmCustomers.Show rs.Close End Sub Thanks, JM runtime-error share|improve this question edited Nov 28 '09 at 4:24 Mitch Wheat 214k28345442 asked Nov 28 '09 at 3:48 JM. 612 add a comment| 3 Answers 3 active oldest votes up vote 0 down vote From the error you are reporting, it would seem that at the point you call GetCustomerList() the connection is not open. share|improve this answer edited Nov 28 '09 at 7:25 answered Nov 28 '09 at 4:25 Mitch Wheat 214k28345442 add a comment| up vote 0 down vote In a database, when you create a Memo field that includes an index or when it creates a field name that contains the text automatically indexed, it can not write to the text field that includes more than 3450 characters or so. When you try to write more text in the field or modify existing data, receive an error message similar to the following Exception 3709 http://support.microsoft.com/kb/302525 share|improve this answer answered Dec 20 '12 at 18:40 Elenasys 56.8k11163143 add a comment| up vote 0 down vo
reporting from Access hit me again! It really makes one wonder who at MS comes up with which error to throw when problems occur and how they retain their job. I have http://www.devhut.net/2015/03/31/ms-access-vba-saveastext-error-3709/ been recently trying to address a corrupted databases and finally decided that using the undocumented SaveAsText and LoadFromText functions was my last hope before having to start the database over again. So I went ahead a punched in my command: Application.SaveAsText acForm, "MyFormName", "C:\...\MyFormName.txt" Upon executing the command I received the following: Run-time error ‘3709': The search key was not found in any record. What the?! Can't find what search key in error 3709 what record? Is this the underlying issues with the form and why is has corrupted in the first place? No. The issue has nothing to do with an index or any record. The most irrelevant error I have ever seen coming from Access (and I have seen some truly useless error messages being output by MS Access in the past). The problem after a quick test was simply due to the fact that access macro error the VBA project was protected and I had not unlocked the project with the appropriate password. So for anyone else trying to perform a SaveAsText and getting this ridiculous error message, ask yourself did you unlock the VBA project. If not, do so and try again. Now that we solved this problem, hopefully someone at Microsoft could start providing error messages pertinent to the actual problem at hand, but I'm not holding my breath on that one! View ratings Rate this article Rate this article Article ratingsCurrent average ratings. Ease of understanding 5.0 1 rating Helpful/Useful 5.0 1 rating Complete 5.0 1 rating Easy to find 5.0 1 rating I am highly knowledgeable about this topic (optional) I have a relevant college/university degree It is part of my profession It is a deep personal passion Submit Ratings Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment *Name * Email * Website Please note: JavaScript is required to post comments. Post navigation MS Access - VBA - Close All Open Forms FMS Inc - Total Access Detective - Review Search for: Our Current Poll Do you find pre-installed software (often called bloatware) useful? Yes No View Results Loading ... Polls Archive Recent Posts Wscript.shell Specialfolders Not Behaving