Discuss This Question: 1  Reply There was an error processing your information. Run Time Error 3709 Access Join our community for more solutions or to ask questions.

with your description of the problem, we can provide a tested, verifiable solution to your question! All rights reserved. It is either closed or invalid in this context." PLease find the logic below Sub Button1_Click() Dim con As ADODB.Connection Dim rs As ADODB.Recordset Dim sqlstr As String Dim strconn As You cannot edit your own topics. Run-time Error '3709' Requested Operation Requires An Ole Db

beginner15 pts. I was trying to do one, then the other. Send me notifications when members answer or reply to this question. Privacy Follow Thanks!

Share Share this post on Digg Del.icio.us Technorati Twitter Thanks, hsk Progress is not made by early risers, but by the LAZY people, trying to find easier ways to do the It Is Either Closed Or Invalid In This Context I've forwarded this on to the developers. You cannot post new polls.

heres my code which I have used successfully in several other screens.whats the story.

We are trying to migrate to a Windows2K/SQL2K server currently named "newserver". A six-sided die is rolled 5 times. David Tags Application Best Practice Exception Modifier Quick Tips SQL VBA Comments (2) Cancel reply Name * Email * Website Leslie Vail says: 11 April 2013 at 11:37 Great tip David! Run Time Error 3709 In Excel Vba My sheet is having records ...

Feynman Diagrams: Ugly u-channel Why is root mean square used when calculating average power, and not simply the average of voltage/current? If you post a question, make sure you include a CREATE TABLE... Do you need your password? Your Email This email is in use.

I hope you will customize the thnig i have given you according to your needs. You cannot edit other topics. Insults are not welcome. When answering a question please: Read the question carefully.

You cannot send private messages. Ask a Question Question Title: (150 char. Following Share this item with your network: 12,630,410 members (30,210 online) Sign in Email Password Forgot your password? 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

But I'm getting the error mentioned above. connection is closed.. statement and INSERT INTO... mean while I used a module in which i put the following codes : Public cn As ADODB.Connection Public Sub Main() Dim cn As ADODB.Connection Set cn = New ADODB.Connection cn.ConnectionString

Get 1:1 Help Now Advertise Here Enjoyed your answer? Please try again later. LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Join Now For immediate help use Live now!

Please try again later. Get Access Questions & Answers ? Please try again later. Leslie Reply David Musgrave says: 17 April 2013 at 17:28 Posting from Mark Polino at DynamicAccounting.net http://www.msdyngp.com/…/quick-tip-vba-ado-connection-run-time-error-3709-developing-for-dynamics-gp-site-home-msdn-blogs Reply Skip to main content Follow UsPages & Portals Developer & Consultant Articles &

Let's work to help developers, not make them feel stupid. Post #168159 jack-64275jack-64275 Posted Thursday, March 17, 2005 1:35 PM SSC-Enthusiastic Group: General Forum Members Last Login: Friday, December 16, 2011 11:21 AM Points: 169, Visits: 559 For what ever reason All contents Copyright 1998-2016 by MrExcel Consulting. You cannot post IFCode.

© Copyright 2017 mwdsoftware.com. All rights reserved.