I have running one application (.mde file) of MS access 2003, quite a long time on Windows XP, - it was working well. Recently on my PC was installed SAS, 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?
16  29915 
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.
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 while creating new folder by
Set fs = CreateObject("Scripting.FileSystemObject")
...
fs.CreateFolder (path)
...
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.
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
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.
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.
From what you have said, no references are missing, but you are gettng a registraton error when you reference the file scripting object....implying that you need to register a dll using regsrvr32. Are you using an activeX frrom a third party?
It doesn't look like a problem with library referencing.
It looks like a problem with: - Library registration. Try to reregister scrrun.dll
- Antivirus software blocking scripting commands (e.g. Kaspersky Office suit is known to do it). Try to temporarily disable antivirus and antimalware software.
No. As I said already, I was registering msadox.dll, didn't help.
If sas is a 3rd party activeX, you probably need to register it using your windows os regsrvr32.
@FelixS
I don't think msadox.dll is an issue, try to reregister scrrun.dll.
scrrun.dll: Search returns no results on my PC C:\
Try to search registry HKCR\CLSID for subkey with "Scripting" in a case your library has other name.
Or better search registry for "Microsoft Scripting Runtime" or try to reference it from VBA editor and then find path to the dll.
1. Status for now: Problem is not solved.
2. Suspicion that installation of SAS principally causes this problem has not confirmed, since on the other PC in the unit SAS and MS access are working well together, the module in quesion has been copied there and tested.
3. I can't catch the step-by-step actions to test the last suggestion:
<<Or better search registry for "Microsoft Scripting Runtime" or try to reference it from VBA editor and then find path to the dll.>>
since the "find" in registry with "Microsoft Scripting Runtime" returns nothing, in VBA reference box there is no library with that name, and if there were, How to "...then find path to the dll. "
Hellow Felix.
That means there is no Microsoft Scripting Runtime library registered and taking into account post #13 there is no correspondent dll at all (at least with a name it exists in Win XP). I don't have an answer as for when and why it has been lost. :)
So, download scrrun.dll ( here for example) and register it with regsrvr32.
Regards,
Fish.
Dear Fish, Your last recommendation has solved the problem!.
Thank you very much. Now it works as expected.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Ange T |
last post by:
Hi there,
I'm having pain with the VB behind an Access form. The form is used to
create reports in Excel based on the details entered in the form. This
has always worked without error on my...
|
by: Andante.in.Blue |
last post by:
Our Access 97 database is a single-file (non-splitted, pure Access)
hosted no a network server, accessed regularly by a handful of users
around the office.
Until recently (until the Great...
|
by: Lisa |
last post by:
Can anyone help me with an "Automation Error" I am receiving in Access
XP? I am using the Combo Box wizard to create a combo box on a simple
form and receive the following error "Automation Error....
|
by: Gunther |
last post by:
Hi,
I have tried the example from the KB article 817248
(http://support.microsoft.com/kb/817248/en-us) in Visual Basic AND in C# with
..NET Framework 2.0:
<ComClass(ComClass1.ClassId,...
|
by: Tremendo |
last post by:
Hi,
I have two PCs:
PC1: Visual Studio 2005 (including .NET framework 2.0.
PC2: Visual Studio 6 (using Visual Basic 6) + .NET framework 2.0 installed separately.
On PC1 I wrote and built a C#...
|
by: Bruce |
last post by:
Hello,
I know this must be something simple I'm overlooking but I can't get
err.raise inside a class to return anything but 440 - automation
error. For example, if I create the following test...
|
by: deco |
last post by:
I try to list the contents of folder by usinng the FileSystemObject Library the
run-time error '-2147319779(8002801d)'; automation error library not registred
is appears but i use the same...
|
by: sanju4kk |
last post by:
-2147319779(8002801d) Automation error library not registered.. while logging in vb application ..help me.. thanx in advance
|
by: nikhilkajrekar |
last post by:
For Each objObj In .CurrentProject.AllForms
DoEvents
intObj = intObj + 1
.DoCmd.OpenForm objObj.Name, acDesign, , , , acHidden
Set objForm = .Forms(objObj.Name)
With...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
| |
