I have recently been provided with a new laptop. The old one ran Win
2000 with Access 2000 and the new one runs Win XP with Access 2000.
When I try to run some of my modules in my old databases on the new
machine, I receive a runtime error "Class Not Registered" on the first
step where I open a table:
rs.Open "[Tbl_Agent]", CurrentProject. Connection, _
adOpenKeyset, adLockOptimisti c
Anyone have any idea what might be wrong? I checked my references and
they are set the same on my old laptop as they are on the new one.
The old PC had MDAC 2.5 and the new one does also. I downloaded MDAC
2.8 and still got the same error.
Any suggestions would be greatly appreciated.
Scott
4  4175 
"Scott Dillard" <sd******@mcint oshassociates.c om> wrote in message
news:63******** *************** ***@posting.goo gle.com... I have recently been provided with a new laptop. The old one ran Win
2000 with Access 2000 and the new one runs Win XP with Access 2000.
When I try to run some of my modules in my old databases on the new
machine, I receive a runtime error "Class Not Registered" on the first
step where I open a table:
rs.Open "[Tbl_Agent]", CurrentProject. Connection, _
adOpenKeyset, adLockOptimisti c
Anyone have any idea what might be wrong? I checked my references and
they are set the same on my old laptop as they are on the new one.
The old PC had MDAC 2.5 and the new one does also. I downloaded MDAC
2.8 and still got the same error.
Any suggestions would be greatly appreciated.
Scott
Scott, you may be missing a reference to ADO (your syntax is ADO). Go to
the modules window, choose Tools->References and make sure Microsoft ActiveX
Data Objects is selected. Select it, then compile to check it.
"Randy Harris" <ra***@SpamFree .com> wrote in message news:<9c******* *************@n ewssvr28.news.p rodigy.com>... "Scott Dillard" <sd******@mcint oshassociates.c om> wrote in message
news:63******** *************** ***@posting.goo gle.com... I have recently been provided with a new laptop. The old one ran Win
2000 with Access 2000 and the new one runs Win XP with Access 2000.
When I try to run some of my modules in my old databases on the new
machine, I receive a runtime error "Class Not Registered" on the first
step where I open a table:
rs.Open "[Tbl_Agent]", CurrentProject. Connection, _
adOpenKeyset, adLockOptimisti c
Anyone have any idea what might be wrong? I checked my references and
they are set the same on my old laptop as they are on the new one.
The old PC had MDAC 2.5 and the new one does also. I downloaded MDAC
2.8 and still got the same error.
Any suggestions would be greatly appreciated.
Scott
Scott, you may be missing a reference to ADO (your syntax is ADO). Go to
the modules window, choose Tools->References and make sure Microsoft ActiveX
Data Objects is selected. Select it, then compile to check it.
Randy, I checked it and the Microsoft ActiveX Data Object is selected.
This is a VBA app within an Access module so I don't think it can be
compiled. When I go into debug mode and put the cursor over the code
line in error, I see "CurrentProject .Connection = <Class not
registered>". Any other suggestions welcome. Thanks.
Scott, I was truly hoping that someone smarter than me would chime in here
and give you the answer. I'm only guessing, but it sounds as though your
ADO library isn't registered in the OS. Have you tried selecting a
different version of ADO, just to see if that would work?
Or, you could try simply registering the appropriate DLL. The command would
be something like:
Regsvr32 msado26.dll
Randy
"Scott Dillard" <sd******@mcint oshassociates.c om> wrote in message
news:63******** *************** ***@posting.goo gle.com... "Randy Harris" <ra***@SpamFree .com> wrote in message
news:<9c******* *************@n ewssvr28.news.p rodigy.com>... "Scott Dillard" <sd******@mcint oshassociates.c om> wrote in message
news:63******** *************** ***@posting.goo gle.com... I have recently been provided with a new laptop. The old one ran Win
2000 with Access 2000 and the new one runs Win XP with Access 2000.
When I try to run some of my modules in my old databases on the new
machine, I receive a runtime error "Class Not Registered" on the first
step where I open a table:
rs.Open "[Tbl_Agent]", CurrentProject. Connection, _
adOpenKeyset, adLockOptimisti c
Anyone have any idea what might be wrong? I checked my references and
they are set the same on my old laptop as they are on the new one.
The old PC had MDAC 2.5 and the new one does also. I downloaded MDAC
2.8 and still got the same error.
Any suggestions would be greatly appreciated.
Scott
Scott, you may be missing a reference to ADO (your syntax is ADO). Go
to the modules window, choose Tools->References and make sure Microsoft
ActiveX Data Objects is selected. Select it, then compile to check it.
Randy, I checked it and the Microsoft ActiveX Data Object is selected.
This is a VBA app within an Access module so I don't think it can be
compiled. When I go into debug mode and put the cursor over the code
line in error, I see "CurrentProject .Connection = <Class not
registered>". Any other suggestions welcome. Thanks.
Thanks Randy but no luck. I have downloaded and reinstalled the MDAC
files, the latest Jet files, and also registered the DLL but still now
luck. It has something to do with the .Connection I think because
CurrentProject works with other commands/methods?
Scott
"Randy Harris" <ra***@SpamFree .com> wrote in message news:<nV******* *************@n ewssvr28.news.p rodigy.com>... Scott, I was truly hoping that someone smarter than me would chime in here
and give you the answer. I'm only guessing, but it sounds as though your
ADO library isn't registered in the OS. Have you tried selecting a
different version of ADO, just to see if that would work?
Or, you could try simply registering the appropriate DLL. The command would
be something like:
Regsvr32 msado26.dll
Randy
"Scott Dillard" <sd******@mcint oshassociates.c om> wrote in message
news:63******** *************** ***@posting.goo gle.com... "Randy Harris" <ra***@SpamFree .com> wrote in message
news:<9c******* *************@n ewssvr28.news.p rodigy.com>... "Scott Dillard" <sd******@mcint oshassociates.c om> wrote in message
news:63******** *************** ***@posting.goo gle.com...
> I have recently been provided with a new laptop. The old one ran Win
> 2000 with Access 2000 and the new one runs Win XP with Access 2000.
> When I try to run some of my modules in my old databases on the new
> machine, I receive a runtime error "Class Not Registered" on the first
> step where I open a table:
>
> rs.Open "[Tbl_Agent]", CurrentProject. Connection, _
> adOpenKeyset, adLockOptimisti c
>
> Anyone have any idea what might be wrong? I checked my references and
> they are set the same on my old laptop as they are on the new one.
>
> The old PC had MDAC 2.5 and the new one does also. I downloaded MDAC
> 2.8 and still got the same error.
>
> Any suggestions would be greatly appreciated.
>
> Scott
Scott, you may be missing a reference to ADO (your syntax is ADO). Go to the modules window, choose Tools->References and make sure Microsoft ActiveX Data Objects is selected. Select it, then compile to check it.
Randy, I checked it and the Microsoft ActiveX Data Object is selected.
This is a VBA app within an Access module so I don't think it can be
compiled. When I go into debug mode and put the cursor over the code
line in error, I see "CurrentProject .Connection = <Class not
registered>". Any other suggestions welcome. Thanks.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: RichGolebiowski |
last post by:
I have a class library (clsTestLib) that was created in VB.Net that I
would like to use in Access 2000. I created a typelib for the class
using regasm.exe. I am able to refernce (add a reference) the dll
using the generated typelib. In Access, when I run the Access
application and declare a new instance of the class as follows
Dim MyTest As clsTestLib.Class1
Set MyTest = New clsTestLib.Class1
I get an error Run-time message that says...
|
by: mark |
last post by:
In Access 2000 and 2002, I have created an import specification to import the
fixed-width recordset below into an existing table. I am having strange
problems with the import of the date and time fields.
177 102003 16:43:12 102003 18:43:12 6OAG0ADP Y 0000 0000 0000 0000 61930 4HGA800
165 102003 17:43:12 102003 18:44:12 6OAG0ADP Y 0000 0000 0000 0000 61930 4HGA800
177 102003 16:41:18 102003 18:45:12 6OAG0ADP Y 0000 0000 0000 0000 61930...
|
by: rua17 |
last post by:
I add tow Com libraries to my project, I can see their content with
intellisense, but when I instantiate a class contained in the library:
PDDirectLib.PDDatabaseQuery pDbQuery = new PDDirectLib.PDDatabaseQuery();
It raises an unhandled exception "Class not registered"
any idea???
|
by: Jim |
last post by:
Have fully operational software package developed on VB.NET that worked until Jan 1 2003, with early stage deployments on Oct 10, Oct 23, Nov 11, Dec 12 and Dec 30.
When attempted final deployment on Jan 2, 2004 got following messages and errors...
I reset everything and tried several times agian. Then erased the setup project and tried to rebuild a new one with the same errors. PLease note... ALL this this code ran perfectly five minutes...
|
by: coosa |
last post by:
Hi,
I was installing SQL Server on my machine and during installation my PC
freezed. It happens frequently on my machine. So i tried after
restarting to install it again and since then i always get the same
error message:
"An error occurred while creating one or more registry entries. Please
see C:\WINDOWS\sqlstp.log for details. The problem could be caused by a
low registry quota condition"
I have tried to clean the registry and i...
| | |
by: papaja |
last post by:
Hello,
I believe I didn't change anything on my machine but my web
applications, particularly pages accessing Microsoft Access DB,
suddenly refused to work.
I get this error:
----------------------------------------------------------
Server Error in '/tulumovic' Application.
|
by: Marek Murin |
last post by:
Hi all,
I have created vb.net user control that has to be used by vb6 form.
Everything goes well with putting the vb.net user control on the VB6 form
until I want to receive any event from my control. The event handler is
displayed on VB6 IDE combo and you can create a sub for it as usual, but when
I run the vb6 form to test it, it won't work.
I have spent too much time til now with that without finding solution.
Can anybody help me ?
|
by: |
last post by:
Hi All,
I have several classic asp pages in site that were originally programmed
with Visual Interdev (or Visual Web Developer Alpha... remember that?). The
pages use the Script Library objects for Recordset and Data Grid
functionality. The database is an Access mdb file that we connect to.
The app was recently moved from a Windows 2000, IIS 5 server to a Windows
2003 IIS 6 server. The permissions, database connections info etc was...
|
by: partybob99 |
last post by:
Hi everyone.
I have a very strange problem and I have no idea how to correct it.
I created a VB.NET DLL that is used by several different apps for
password file encryption/decryption. I have the original .NET DLL and
I also built the DLL with a COM wrapper (the COM interop box checked in
the project...) so it can be used with VB6 apps (or any other language
for that matter). In order for a VB6 app to use this DLL, this control
must...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
