Ms Access Error Code 3146
Contents |
your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link run time error 3146 odbc call failed access above to proceed. To start viewing messages, select the forum that you
Run Time Error 3146 Odbc Call Failed Access 2010
want to visit from the selection below. Results 1 to 5 of 5 Thread: ODBC - Connection Failed Error run time error 3146 odbc call failed oracle 3146 Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 05-05-09,19:17 #1 shanmugha View Profile
Access Macro Error 3146
View Forum Posts Registered User Join Date May 2009 Posts 8 Unanswered: ODBC - Connection Failed Error 3146 Hi, I have a situation here.I will be glad if anyone could help. We have a Microsoft Access 2003 accessing the SQL Server 2000 database using ODBC connection.I have set the database as a System Datasource with SQL Server driver and the connection settings. When i run time error 3146 odbc call failed mysql launch the .mdb application,i am able to connect to the database and fetch results.But only while populating the data on one of the combobox,the ODBC connection failed error 3146 arises. I turned on the tracing and saw that the SetConnection Attr failed error in the log. Any help is highly appreciated. Thanks in advance. Reply With Quote 05-05-09,20:24 #2 pkstormy View Profile View Forum Posts Moderator Join Date Dec 2004 Location Madison, WI Posts 3,926 Are you able to enter data for this field directly into the table? If not, are you able to enter data in this field directly into the SQL Server table (I'm guessing yes.) You can also try refreshing (or delete and relink) the linked tables. You can also put in a msgbox me!MyProblemField in the AfterUpdate (or BeforeUpdate) event to see what value is actually being saved in the combobox and see if it matches the SQL Server field type. I'm not sure what the error exactly means but these are some things I normally do to troubleshoot. My guess is that you may not be passing the correct value type for that field
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 21:25:55 GMT by s_wx1157 (squid/3.5.20)
sophisticated digital experiences Web content & Customer Journey Sitefinity CMS Build engaging websites with intuitive web content management Application Development, Testing & Deployment DevCraft Leverage a complete UI toolbox for web, mobile and desktop http://knowledgebase.progress.com/articles/Article/Run-Time-Error-3146-When-Running-Query-From-MS-Access-Linked-Tables development OpenEdge Build, protect and deploy apps across any platform and mobile device Kendo UI Build rich, smart HTML5 and JavaScript apps for any platform, browser or device Telerik Platform Build http://www.utteraccess.com/forum/index.php?showtopic=1993453 mobile apps for iOS, Android and Windows Phone Nativescript Use Angular, TypeScript or JavaScript to build truly native mobile apps Rollbase Rapidly develop, manage and deploy business apps, delivered as error 3146 SaaS in the cloud Test Studio Automate UI, load and performance testing for web, desktop and mobile Modulus Host, deploy and scale Node.js, Java and .NET Core apps on premise or in the cloud Data Connectivity DataDirect Connectors Optimize data integration with high-performance connectivity Business Rules Management Corticon Automate decision processes with a no-code business rules engine View All Products Solutions Digital run time error Business Transformation Transform your businesses in order to survive in a completely digitized and connected world driven by software innovation. Web Scale Globally scale websites with innovative content management and infrastructure approaches Modernization UX and app modernization to powerfully navigate todays digital landscape Omni-Channel Engagement Content-focused web and mobile solution for empowering marketers aPaaS Fuel agility with ever-ready applications, built in the cloud Enterprise Mobility Faster, tailored mobile experiences for any device and data source New & Trending E-book The Digital Ultimatum: Why Businesses Must Digitally Transform to Survive â€" and Thrive Survey Report The State of Digital Business Support & Learning Support Support Services Knowledge Base Customer Order Management Download Center Services Training Consulting Services Managed Database Offering Learning Documentation Webinars How-To Videos Whitepapers Community Blogs Success Stories Partners Company Login Progress Support Rollbase DataDirect Cloud PartnerLink Telerik Your Account Telerik Platform Global Sites Brazil France Germany Netherlands United States Menu 1-800-477-6473 CONTACT SALES Knowledge Base 000059053 < Back to search results Run Time Error 3146 When Running Query From MS Access Linked Tables using DataDirect Cloud ODBC driverPrintable View &la
Custom Search UtterAccess Forums>Microsoft® Access>Access Q and A Runtime Error 3146, Access 2010 Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code Archive|-- Access Knowledgebase / FAQ|-- Access TutorialsMicrosoft® Access|-- Local Access User Groups (AUGs)|-- Interface Design|-- Access Q and A|-- Access Tables + Relationships|-- Access Queries|-- Access Forms|-- Access Reports|-- Access Macros|-- Access Modules|-- Access Date + Time|-- Access Errors + Error Handling|-- Access Built-in Functions|-- Access Searching + Data Mining|-- Access Records|-- Access Security|-- Access Automation|-- Access Database Container|-- Tool bars, Menu bars + Ribbon|-- Access Services (Web Databases)|-- Access Data Access Pages (Deprecated)|-- Access Data Projects - ADP|-- Access Runtime, Packaging & DeploymentAnd More...|-- Microsoft SQL Server|-- SQL Server Reporting Services|-- Microsoft SharePoint|-- Microsoft Internet Explorer|-- Visual Basic 6 and Earlier|-- Visual Basic 2003 and Later|-- ASP and VBScript|-- Web Development|-- PHP, Perl, MySQL and Postgres|-- Other Database Engines|-- BI Tools and Applications|-- JAVA and C#|-- GraphicsMicrosoft® Office|-- Microsoft Excel|-- Microsoft Excel FAQs|-- Microsoft Word|-- Microsoft Outlook|-- Microsoft PowerPoint|-- Microsoft FrontPage/Exp. Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- Q & A - UtterAccess.com Forums|-- Q & A - Access Wiki Options Mme_FriantineView Member Profile Sep 17 2012, 11:27 AM Post#1Posts: 68Joined: 6-September 12Hi,since I moved and linked the backend on SQL server 2012, I got a runtime error 3146 with this codeDim db As DAO.Database, rstForms As DAO.Recordset, rstUserP As Recordset DoCmd.OpenForm "Security_NewUser", , , , , acDialog If intEmployeeID = 0 Then Exit Sub End IfSet db = CurrentDb() Set rstForms = db.OpenRecordset("Security_AppForms", dbOpenDynaset, dbSeeChanges) Set rstUserP = db.OpenRecordset("Security_UserPermissions", dbOpenDynaset, dbSeeChanges) Do While Not rstForms.EOF With rstUserP .AddNew !EmployeeID = intEmployeeID !FormID = rstForms!FormID !Read = True .Update End With rstForms.MoveNext LoopOn the update.It on