Access Vba Automation Error Library Not Registered
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Fri, 30 Sep 2016 01:26:59 GMT by s_hv977 (squid/3.5.20)
be down. Please try the request again. Your cache administrator is webmaster. Generated Fri, 30 Sep 2016 01:26:59 GMT by s_hv977 (squid/3.5.20)
Need help? Post your question and get tips & solutions from a community of 418,417 IT Pros & Developers. It's quick & easy. Automation Error -- Library not registered. P: 16 FelixS I have running one application (.mde file) of MS access 2003, quite a https://bytes.com/topic/access/answers/863061-automation-error-library-not-registered long time on Windows XP, - it was working well. Recently on my PC was installed SAS, http://p2p.wrox.com/pro-vb-6/60655-runtime-automation-error-library-not-registered.html after that while running my .mde application I am getting message "Automation Error -- Library not registered". I have found in WEB one recommendation - register module msadox.dll. Regsvr32.exe "C:\Program Files\Common Files\System\ado\msadox.dll" Doesn't help. The same module is working well on my laptop, not affected by installation any new software. Any suggestions? Feb 9 '09 #1 Post Reply Share this Question 16 Replies Expert 100+ P: 1,923 puppydogbuddy automation error You need to check for missing references in your Access vb library. To do this place any of your forms in design view and go to the code editor. Once you are in the Code view, go to the Access command menu, and select Tools> References, checking for any missing references. Feb 9 '09 #2 reply P: 16 FelixS Well, How I know which library is not connected (referenced). Usually there are only 5-6 out of many available.In fact, I have found already that error occurs vba automation error while creating new folder by Set fs = CreateObject("Scripting.FileSystemObject") ... fs.CreateFolder (path) ... Feb 9 '09 #3 reply Expert 100+ P: 1,923 puppydogbuddy when you open up the references library it will tell you which one (if any) are missing. You will see the words Missing beside the missing library reference. Feb 9 '09 #4 reply P: 16 FelixS In my version of MS Visual Basic, when I go to Tools->References I see the Box with names of libraries and box for ticking before each name. No "MISSING" words. In the list of available references now there are 5 ticked ones, The others are empty. First of all, I think, this was also before it happens. Besides, I have no idea, what another library I need Feb 9 '09 #5 reply Expert 100+ P: 1,923 puppydogbuddy I just realized that you are looking at your mde file which has the code stripped out. You need to use your mdb file to determine which file is missing. In order to make a determination using an mde file, you would have to embed reference checking code behind a module that you could call from a button on a form. Feb 9 '09 #6 reply P: 16 FelixS no - no -no. I am exercising with *.mdb original file. Ones more, when copying it to another machine, where SAS is not installed, I can observe it working as expected. Feb 9 '09 #7 reply Expert 100+ P: 1,923 puppydogbuddy From what you have said, no references
Unanswered Topics Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Pro VB 6 runtime automation error library not registered User Name Remember Me? Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search Pro VB 6 For advanced Visual Basic coders working in version 6 (not .NET). Beginning-level questions will be redirected to other forums, including Beginning VB 6. Search Forums Show Threads Show Posts Advanced Search Find All Thanked Posts Go to Page... Welcome to the p2p.wrox.com Forums. You are currently viewing the Pro VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free . Thread Tools Display Modes #1 (permalink) July 30th, 2007, 04:44 PM deco Registered User Join Date: Apr 2007 Location: , , Libya. Posts: 5 Thanks: 0 Thanked 0 Times in 0 Posts runtime automation error library not registered I try to list the contents of folder by using the FileSystemObject Library the run-time error '-2147319779(8002801d)'; automation error library not registered is appears buti use the same application in another computer and its run i check the reference microsoft scripting runtime the code Code: Dim FSO As New FileSystemObject Dim FileInFolder As Files Dim FileName As File Dim I As Integer Dim FolderInPath As String Private Sub Command1_Click() Set FileInFolder = FSO.GetFolder("C:\Program Files\NowSMS\SMS-IN").Files For Each FileName In FileInFolder List1.AddItem FileName DoEvents Next For I = 0 To List1.ListCount - 1 FolderInPath = Replace(List1.List(I), "C:\Program Files\NowSMS\SMS-IN\", App.Path & "\CopyOf(SMS-IN)\" & "(" & I & ")") FSO.CopyFile List1.List(I), FolderInPath, False Next I End Sub deco #2 (permalink) July 30th, 2007, 11:27 PM Shasur Friend of Wrox Points: 3,060, Level: 23 Activity: 0% Join Date: Sep 2005 Location: , , . Posts: 812 Thanks: 1