I'm using ADO to perform the commands. Run-time error '-2147217843 (80040e4d)': Authenication failed. The 1st time the app is run, the config screen should load an allow the user to choose the location of the DB, click the "Dont show form" check box. VB Code: Private sub form_load() On error goto MyError100 Set rs = new adodb.recordset110 rs.open "SELECT * FROM Table1"120 '...130 '...
I used connection string to connect database server, when my app open connection (conn.open), my connection string changes itself, and there is NO PASSWORD in there, so my code gives me The error I get is, "Run-time error '-2147217843(80040e4d)': Automation error". 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 As a test, you could edit the Vbp to switch the two, putting Ado first The good solution should be to specify in code "ADODB." as prefix to your ado objects http://forums.codeguru.com/showthread.php?339784-VB6-Run-time-error-2147217843-(80040e4d)-Not-a-valid-Password
Also explore the possibility of using DSNless connection string. but I'll copy and paste my project and a newly saved blank project. Thanks RobDog. It's quick & easy.
I've never seen that error before on that machine, and the user does have admin rights. Any suggestions? 4. I bet you compiled on an XP system? Try that simple task first to see if it fixes the error code problem.
Add line numbers in your form load event and error handling like this. Does it work on all XP machines? MS SQL Server Query Current Session Information via SQL Video by: Steve This videos aims to give the viewer a basic demonstration of how a user can query current session information https://www.experts-exchange.com/questions/28303053/Access-2010-VBA-Run-time-error-'-2147217843-80040e4d-'-Authenication-failed.html Specific causes and solutions for Run Time Error 2147217843 80040e4d errors Reboot your PC.
Save it and then open the vbp with notepad. Visit our Linux sister site. Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not To activate it, click the "Start" button and enter "memory" in the "Run" field.
Try Robert Gelb's approach: http://www.vbrad.com/article.aspx?id=81 Works for me every time. https://bytes.com/topic/access/answers/636706-run-time-error-2147217843-80040e4d-connecting-external-database acperkins gave the answer. 2147217843 Login Failed I dont answer coding questions via PM or EMail. Excel System Error &h80040e4d Set .ActiveConnection = Nothing 'Disconnect the recordset.
Raiders #1 AKA:Gangsta Yoda™ Posts 60,220 Re: Runtime error 214721783(80040e4d) Authentication failed You can download MDAC from MS and upgrade the 2k machines but you should only do this after determining Another way could be: remove ado reference from project, save it, close, reopen, add reference to Ado 2.8, save and then test again... Also, Run Time Error 2147217843 80040e4d errors are very common during PC restarts that immediately follow a previous improper shutdown and recent virus or malware infection recovery. Could you be missing a dependancy file(s). Run Time Error
All times are GMT -5. Unfortunately I dont have VB installed on any of our 2k Machines. The time now is 10:38 PM. Not surprisingly I've run into difficulty.
In many instances, a Run Time Error 2147217843 80040e4d error code could have multiple Run Time Error 2147217843 80040e4d parameters. Go to Solution 10 Comments LVL 58 Overall: Level 58 MS SQL Server 18 Message Expert Comment by:amit_g2003-04-23 Post the VB code. 0 LVL 2 Overall: Level 2 MS Originally Posted by RobDog888 What does your app do?
Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! It keeps me sharp covering all kinds of topics. stSQL1 = "Select Top 1 QUESTIONCODE, REGULATORYANSWER, INPRACTICERESPONSE From vMasterData where QUESTIONCODE = 'GQ-005';" 'The 2nd raw SQL-statement to be executed. 'stSQL2 = "SELECT Then I would add error handling and line numbers to your form load event so you can pinpoint the error if its not MDAC.
I only explained it. 0 Write Comment First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. What are the main varieties of Castillan Spanish in the world? Please post a thread in the appropriate forum. Windows system file entry corruption is a serious matter, as it often means a malfunction that may pose a major security risk.
sconnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" & frmLocation.Text1.Text & "';Persist Security Info=False" should be... System memory defects.