|
 |
access thread: ActiveX Component can't create object
Message #1 by "stephen" <stephen@v...> on Wed, 27 Feb 2002 01:08:24
|
|
Hi, I am trying to run the following code:
Dim rs As Recordset
Set rs = New Recordset
On a windows 98 computer with access 200 just installed on it.
I get the error message:
Err. ActiveX Component can't create object.
I have the latest dll's installed and refferenced so i cannot understand
why this would happen?
Any help on this please wouldn be much appreciated as i have already spent
quite sometime trying to firgure this one out.
Kind Regards,
Sephen
Message #2 by "John Ruff" <papparuff@c...> on Tue, 26 Feb 2002 17:27:51 -0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_004F_01C1BEEA.EB375020
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Two things.
You must set a reference to Microsoft DAO x.x Object Library and you
must qualify your recordset
1. Open any module and go to Tools > References and check off the
Microsoft DAO x.x Object Library (where x.x is your latest version)
2. Change your Dim rs statement to Dim rs as dao.recordset
John Ruff - The Eternal Optimist J
Always looking for Contract Opportunities
9306 Farwest Dr SW
Lakewood, WA 98498
papparuff@c...
-----Original Message-----
From: stephen [mailto:stephen@v...]
Sent: Wednesday, February 27, 2002 1:08 AM
To: Access
Subject: [access] ActiveX Component can't create object
Hi, I am trying to run the following code:
Dim rs As Recordset
Set rs = New Recordset
On a windows 98 computer with access 200 just installed on it.
I get the error message:
Err. ActiveX Component can't create object.
I have the latest dll's installed and refferenced so i cannot understand
why this would happen?
Any help on this please wouldn be much appreciated as i have already
spent
quite sometime trying to firgure this one out.
Kind Regards,
Sephen
Message #3 by "Stephen Woods" <stephen@v...> on Wed, 27 Feb 2002 12:36:58 +1100
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0014_01C1BF8B.73A3D280
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
MessageYes but i am using ADO?
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Wednesday, 27 February 2002 12:28 PM
To: Access
Subject: [access] RE: ActiveX Component can't create object
Two things.
You must set a reference to Microsoft DAO x.x Object Library and you must
qualify your recordset
1. Open any module and go to Tools > References and check off the
Microsoft DAO x.x Object Library (where x.x is your latest version)
2. Change your Dim rs statement to Dim rs as dao.recordset
John Ruff - The Eternal Optimist J
Always looking for Contract Opportunities
9306 Farwest Dr SW
Lakewood, WA 98498
papparuff@c...
-----Original Message-----
From: stephen [mailto:stephen@v...]
Sent: Wednesday, February 27, 2002 1:08 AM
To: Access
Subject: [access] ActiveX Component can't create object
Hi, I am trying to run the following code:
Dim rs As Recordset
Set rs = New Recordset
On a windows 98 computer with access 200 just installed on it.
I get the error message:
Err. ActiveX Component can't create object.
I have the latest dll's installed and refferenced so i cannot understand
why this would happen?
Any help on this please wouldn be much appreciated as i have already spent
quite sometime trying to firgure this one out.
Kind Regards,
Sephen
Message #4 by "Leo Scott" <leoscott@c...> on Tue, 26 Feb 2002 18:56:34 -0800
|
|
Under Tools -> Referneces, what libraries are referenced? Do any of them
say Missing? It sounds like you have a broken library reference. You might
try this link:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q296204
|-----Original Message-----
|From: stephen [mailto:stephen@v...]
|Sent: Wednesday, February 27, 2002 1:08 AM
|To: Access
|Subject: [access] ActiveX Component can't create object
|
|
|Hi, I am trying to run the following code:
|
|
|Dim rs As Recordset
|Set rs = New Recordset
|
|
|On a windows 98 computer with access 200 just installed on it.
|
|I get the error message:
|
|Err. ActiveX Component can't create object.
|
|I have the latest dll's installed and refferenced so i cannot understand
|why this would happen?
|
|Any help on this please wouldn be much appreciated as i have already spent
|quite sometime trying to firgure this one out.
|
|Kind Regards,
|Sephen
|
Message #5 by "John Ruff" <papparuff@c...> on Tue, 26 Feb 2002 19:02:13 -0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0003_01C1BEF8.1A09A0D0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Sorry Steven,
Sometimes the most obvious is easily missed.
Change
Set rs = New Recordset
To
Set rs As New Recordset
John Ruff - The Eternal Optimist J
Always looking for Contract Opportunities
9306 Farwest Dr SW
Lakewood, WA 98498
papparuff@c...
-----Original Message-----
From: stephen [mailto:stephen@v...]
Sent: Wednesday, February 27, 2002 1:08 AM
To: Access
Subject: [access] ActiveX Component can't create object
Hi, I am trying to run the following code:
Dim rs As Recordset
Set rs = New Recordset
On a windows 98 computer with access 200 just installed on it.
I get the error message:
Err. ActiveX Component can't create object.
I have the latest dll's installed and refferenced so i cannot understand
why this would happen?
Any help on this please wouldn be much appreciated as i have already
spent
quite sometime trying to firgure this one out.
Kind Regards,
Sephen
Message #6 by "John Ruff" <papparuff@c...> on Tue, 26 Feb 2002 19:04:10 -0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_000F_01C1BEF8.5FCAD620
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Disregard this post, I boo-booed.
John Ruff - The Eternal Optimist J
Always looking for Contract Opportunities
9306 Farwest Dr SW
Lakewood, WA 98498
papparuff@c...
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Tuesday, February 26, 2002 7:02 PM
To: Access
Subject: [access] RE: ActiveX Component can't create object
Sorry Steven,
Sometimes the most obvious is easily missed.
Change
Set rs = New Recordset
To
Set rs As New Recordset
John Ruff - The Eternal Optimist J
Always looking for Contract Opportunities
9306 Farwest Dr SW
Lakewood, WA 98498
papparuff@c...
-----Original Message-----
From: stephen [mailto:stephen@v...]
Sent: Wednesday, February 27, 2002 1:08 AM
To: Access
Subject: [access] ActiveX Component can't create object
Hi, I am trying to run the following code:
Dim rs As Recordset
Set rs = New Recordset
On a windows 98 computer with access 200 just installed on it.
I get the error message:
Err. ActiveX Component can't create object.
I have the latest dll's installed and refferenced so i cannot understand
why this would happen?
Any help on this please wouldn be much appreciated as i have already
spent
quite sometime trying to firgure this one out.
Kind Regards,
Sephen
Message #7 by "Stephen Woods" <stephen@v...> on Wed, 27 Feb 2002 14:25:27 +1100
|
|
Um none say missing.
These are what are selected under refferecnes.
Visual Basic for Applications.
Microsoft Access 9.0 Object Library.
Microsoft ActiveX Data Objects 2.6 Library.
OLE Automation.
All ticked and are not missing.
Thanks, i am checking out the web site now. 8)
Regards,
Stephen
-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Wednesday, 27 February 2002 1:57 PM
To: Access
Subject: [access] RE: ActiveX Component can't create object
Under Tools -> Referneces, what libraries are referenced? Do any of them
say Missing? It sounds like you have a broken library reference. You might
try this link:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q296204
|-----Original Message-----
|From: stephen [mailto:stephen@v...]
|Sent: Wednesday, February 27, 2002 1:08 AM
|To: Access
|Subject: [access] ActiveX Component can't create object
|
|
|Hi, I am trying to run the following code:
|
|
|Dim rs As Recordset
|Set rs = New Recordset
|
|
|On a windows 98 computer with access 200 just installed on it.
|
|I get the error message:
|
|Err. ActiveX Component can't create object.
|
|I have the latest dll's installed and refferenced so i cannot understand
|why this would happen?
|
|Any help on this please wouldn be much appreciated as i have already spent
|quite sometime trying to firgure this one out.
|
|Kind Regards,
|Sephen
|
Message #8 by "Stephen Woods" <stephen@v...> on Wed, 27 Feb 2002 14:28:00 +1100
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_002E_01C1BF9A.FBEEE210
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
MessageI tried Dim rs As New Recordset and foudn i had the same results, (an
error)
thanks for all your help with this as well..
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Wednesday, 27 February 2002 2:02 PM
To: Access
Subject: [access] RE: ActiveX Component can't create object
Sorry Steven,
Sometimes the most obvious is easily missed.
Change
Set rs = New Recordset
To
Set rs As New Recordset
John Ruff - The Eternal Optimist J
Always looking for Contract Opportunities
9306 Farwest Dr SW
Lakewood, WA 98498
papparuff@c...
-----Original Message-----
From: stephen [mailto:stephen@v...]
Sent: Wednesday, February 27, 2002 1:08 AM
To: Access
Subject: [access] ActiveX Component can't create object
Hi, I am trying to run the following code:
Dim rs As Recordset
Set rs = New Recordset
On a windows 98 computer with access 200 just installed on it.
I get the error message:
Err. ActiveX Component can't create object.
I have the latest dll's installed and refferenced so i cannot understand
why this would happen?
Any help on this please wouldn be much appreciated as i have already spent
quite sometime trying to firgure this one out.
Kind Regards,
Sephen
Message #9 by "Haslett, Andrew" <andrew.haslett@i...> on Wed, 27 Feb 2002 14:04:22 +1030
|
|
<guess>
Why would you use:
set rs = New Recordset
Don't use just Dim it and then assign it?
eg.
Dim rs As Recordset
set rs = db.OpenRecordset(whatever)
</guess>
-----Original Message-----
From: stephen [mailto:stephen@v...]
Sent: Wednesday, 27 February 2002 11:38 AM
To: Access
Subject: [access] ActiveX Component can't create object
Hi, I am trying to run the following code:
Dim rs As Recordset
Set rs = New Recordset
On a windows 98 computer with access 200 just installed on it.
I get the error message:
Err. ActiveX Component can't create object.
I have the latest dll's installed and refferenced so i cannot understand
why this would happen?
Any help on this please wouldn be much appreciated as i have already spent
quite sometime trying to firgure this one out.
Kind Regards,
Sephen
Message #10 by "Leo Scott" <leoscott@c...> on Tue, 26 Feb 2002 19:11:36 -0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_00C8_01C1BEF9.69581940
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
MessageI use
Set rs = new ADODB.Recordset
all the time and it works fine.
The help from Access VBA for the Set Statement says:
Set objectvar = {[New] objectexpression | Nothing}
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Tuesday, February 26, 2002 7:02 PM
To: Access
Subject: [access] RE: ActiveX Component can't create object
Sorry Steven,
Sometimes the most obvious is easily missed.
Change
Set rs = New Recordset
To
Set rs As New Recordset
John Ruff - The Eternal Optimist J
Always looking for Contract Opportunities
9306 Farwest Dr SW
Lakewood, WA 98498
papparuff@c...
-----Original Message-----
From: stephen [mailto:stephen@v...]
Sent: Wednesday, February 27, 2002 1:08 AM
To: Access
Subject: [access] ActiveX Component can't create object
Hi, I am trying to run the following code:
Dim rs As Recordset
Set rs = New Recordset
On a windows 98 computer with access 200 just installed on it.
I get the error message:
Err. ActiveX Component can't create object.
I have the latest dll's installed and refferenced so i cannot understand
why this would happen?
Any help on this please wouldn be much appreciated as i have already spent
quite sometime trying to firgure this one out.
Kind Regards,
Sephen
Message #11 by "Leo Scott" <leoscott@c...> on Tue, 26 Feb 2002 19:36:08 -0800
|
|
Try
Dim rs as ADODB.Recordset
Set rs = New ADODB.Recordset
Your references look fine.
|-----Original Message-----
|From: Stephen Woods [mailto:stephen@v...]
|Sent: Tuesday, February 26, 2002 7:25 PM
|To: Access
|Subject: [access] RE: ActiveX Component can't create object
|
|
|Um none say missing.
|
|These are what are selected under refferecnes.
|
|Visual Basic for Applications.
|Microsoft Access 9.0 Object Library.
|Microsoft ActiveX Data Objects 2.6 Library.
|OLE Automation.
|
|All ticked and are not missing.
|
|Thanks, i am checking out the web site now. 8)
|
|Regards,
|Stephen
|
|
|-----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Wednesday, 27 February 2002 1:57 PM
|To: Access
|Subject: [access] RE: ActiveX Component can't create object
|
|
|Under Tools -> Referneces, what libraries are referenced? Do any of them
|say Missing? It sounds like you have a broken library reference.
|You might
|try this link:
|
|http://support.microsoft.com/default.aspx?scid=kb;EN-US;q296204
|
||-----Original Message-----
||From: stephen [mailto:stephen@v...]
||Sent: Wednesday, February 27, 2002 1:08 AM
||To: Access
||Subject: [access] ActiveX Component can't create object
||
||
||Hi, I am trying to run the following code:
||
||
||Dim rs As Recordset
||Set rs = New Recordset
||
||
||On a windows 98 computer with access 200 just installed on it.
||
||I get the error message:
||
||Err. ActiveX Component can't create object.
||
||I have the latest dll's installed and refferenced so i cannot understand
||why this would happen?
||
||Any help on this please wouldn be much appreciated as i have already spent
||quite sometime trying to firgure this one out.
||
||Kind Regards,
||Sephen
||
|
|
|
|
|
Message #12 by "Stephen Woods" <stephen@v...> on Wed, 27 Feb 2002 14:42:43 +1100
|
|
I was always told you had to Instatiate your objects.
Even if you dont isntatirate it, when you go to open the recorset or set it
to something, it then automatically instatiates it.
I was told to instatiate is good practice??
-----Original Message-----
From: Haslett, Andrew [mailto:andrew.haslett@i...]
Sent: Wednesday, 27 February 2002 2:34 PM
To: Access
Subject: [access] RE: ActiveX Component can't create object
<guess>
Why would you use:
set rs = New Recordset
Don't use just Dim it and then assign it?
eg.
Dim rs As Recordset
set rs = db.OpenRecordset(whatever)
</guess>
-----Original Message-----
From: stephen [mailto:stephen@v...]
Sent: Wednesday, 27 February 2002 11:38 AM
To: Access
Subject: [access] ActiveX Component can't create object
Hi, I am trying to run the following code:
Dim rs As Recordset
Set rs = New Recordset
On a windows 98 computer with access 200 just installed on it.
I get the error message:
Err. ActiveX Component can't create object.
I have the latest dll's installed and refferenced so i cannot understand
why this would happen?
Any help on this please wouldn be much appreciated as i have already spent
quite sometime trying to firgure this one out.
Kind Regards,
Sephen
Message #13 by "Stephen Woods" <stephen@v...> on Wed, 27 Feb 2002 14:44:13 +1100
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0038_01C1BF9D.3FBAEC30
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Messageyeah i think it must be the MDAC then, what else could it be, i have
done it all right, works fine off my computer,
my compiuter, windows 2k pro
office 2000
doesnt work on other computers
windows 98,
office 2000
8)
-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Wednesday, 27 February 2002 2:12 PM
To: Access
Subject: [access] RE: ActiveX Component can't create object
I use
Set rs = new ADODB.Recordset
all the time and it works fine.
The help from Access VBA for the Set Statement says:
Set objectvar = {[New] objectexpression | Nothing}
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Tuesday, February 26, 2002 7:02 PM
To: Access
Subject: [access] RE: ActiveX Component can't create object
Sorry Steven,
Sometimes the most obvious is easily missed.
Change
Set rs = New Recordset
To
Set rs As New Recordset
John Ruff - The Eternal Optimist J
Always looking for Contract Opportunities
9306 Farwest Dr SW
Lakewood, WA 98498
papparuff@c...
-----Original Message-----
From: stephen [mailto:stephen@v...]
Sent: Wednesday, February 27, 2002 1:08 AM
To: Access
Subject: [access] ActiveX Component can't create object
Hi, I am trying to run the following code:
Dim rs As Recordset
Set rs = New Recordset
On a windows 98 computer with access 200 just installed on it.
I get the error message:
Err. ActiveX Component can't create object.
I have the latest dll's installed and refferenced so i cannot understand
why this would happen?
Any help on this please wouldn be much appreciated as i have already
spent
quite sometime trying to firgure this one out.
Kind Regards,
Sephen
Message #14 by "Haslett, Andrew" <andrew.haslett@i...> on Wed, 27 Feb 2002 14:22:24 +1030
|
|
Think you're probably right.
I do it in ASP (VBScript) when referencing ADO but I guess have been slack
in access using DAO.
-----Original Message-----
From: Stephen Woods [mailto:stephen@v...]
Sent: Wednesday, 27 February 2002 2:13 PM
To: Access
Subject: [access] RE: ActiveX Component can't create object
I was always told you had to Instatiate your objects.
Even if you dont isntatirate it, when you go to open the recorset or set it
to something, it then automatically instatiates it.
I was told to instatiate is good practice??
-----Original Message-----
From: Haslett, Andrew [mailto:andrew.haslett@i...]
Sent: Wednesday, 27 February 2002 2:34 PM
To: Access
Subject: [access] RE: ActiveX Component can't create object
<guess>
Why would you use:
set rs = New Recordset
Don't use just Dim it and then assign it?
eg.
Dim rs As Recordset
set rs = db.OpenRecordset(whatever)
</guess>
-----Original Message-----
From: stephen [mailto:stephen@v...]
Sent: Wednesday, 27 February 2002 11:38 AM
To: Access
Subject: [access] ActiveX Component can't create object
Hi, I am trying to run the following code:
Dim rs As Recordset
Set rs = New Recordset
On a windows 98 computer with access 200 just installed on it.
I get the error message:
Err. ActiveX Component can't create object.
I have the latest dll's installed and refferenced so i cannot understand
why this would happen?
Any help on this please wouldn be much appreciated as i have already spent
quite sometime trying to firgure this one out.
Kind Regards,
Sephen
Message #15 by "Leo Scott" <leoscott@c...> on Tue, 26 Feb 2002 20:05:23 -0800
|
|
Stephen is using ADO, based on the References he said he had set.
The problem with
Dim rs As New ADODB.Recordset
or the similar line for DAO is that it runs slower. VB doesn't allocate the
memory for it with that declaration until the first time you use the object.
Because of this every time you use the object VB must check to see if it has
been allocated already and this takes time. It is better to Dim and then
Set = New. That allocates at compile time.
|-----Original Message-----
|From: Haslett, Andrew [mailto:andrew.haslett@i...]
|Sent: Tuesday, February 26, 2002 7:52 PM
|To: Access
|Subject: [access] RE: ActiveX Component can't create object
|
|
|Think you're probably right.
|
|I do it in ASP (VBScript) when referencing ADO but I guess have been slack
|in access using DAO.
|
|-----Original Message-----
|From: Stephen Woods [mailto:stephen@v...]
|Sent: Wednesday, 27 February 2002 2:13 PM
|To: Access
|Subject: [access] RE: ActiveX Component can't create object
|
|
|I was always told you had to Instatiate your objects.
|
|Even if you dont isntatirate it, when you go to open the recorset or set it
|to something, it then automatically instatiates it.
|
|I was told to instatiate is good practice??
|
|
|
|-----Original Message-----
|From: Haslett, Andrew [mailto:andrew.haslett@i...]
|Sent: Wednesday, 27 February 2002 2:34 PM
|To: Access
|Subject: [access] RE: ActiveX Component can't create object
|
|
|<guess>
|Why would you use:
| set rs = New Recordset
|
|Don't use just Dim it and then assign it?
|
|eg.
|Dim rs As Recordset
|set rs = db.OpenRecordset(whatever)
|
|</guess>
|
|-----Original Message-----
|From: stephen [mailto:stephen@v...]
|Sent: Wednesday, 27 February 2002 11:38 AM
|To: Access
|Subject: [access] ActiveX Component can't create object
|
|
|Hi, I am trying to run the following code:
|
|
|Dim rs As Recordset
|Set rs = New Recordset
|
|
|On a windows 98 computer with access 200 just installed on it.
|
|I get the error message:
|
|Err. ActiveX Component can't create object.
|
|I have the latest dll's installed and refferenced so i cannot understand
|why this would happen?
|
|Any help on this please wouldn be much appreciated as i have already spent
|quite sometime trying to firgure this one out.
|
|Kind Regards,
|Sephen
|
|
|
|
|
Message #16 by "Stephen Woods" <stephen@v...> on Wed, 27 Feb 2002 15:19:22 +1100
|
|
I am thiking my problem is a result of not having the latest MDAC installed.
(thanks Leo Scott for this lead)
Now i checked the registry on the cpomputer that does work and it found MDAC
version 2.6, then i tried the computer that didnt work and it found MDAC
version 2.5 in the registry, even after installing Office Service Pack 1.
So somehow i need to get MDAC version 2.6 installed on the client machines.
And microsoft ssay the only way you can do this is to do the following.
Install a released service pack.
-or-
Run an operating system Web-based update package.
So far i have only installed Acess 2000 and Office Service pack 1...
Regards,
Stephen
-----Original Message-----
From: Haslett, Andrew [mailto:andrew.haslett@i...]
Sent: Wednesday, 27 February 2002 2:52 PM
To: Access
Subject: [access] RE: ActiveX Component can't create object
Think you're probably right.
I do it in ASP (VBScript) when referencing ADO but I guess have been slack
in access using DAO.
-----Original Message-----
From: Stephen Woods [mailto:stephen@v...]
Sent: Wednesday, 27 February 2002 2:13 PM
To: Access
Subject: [access] RE: ActiveX Component can't create object
I was always told you had to Instatiate your objects.
Even if you dont isntatirate it, when you go to open the recorset or set it
to something, it then automatically instatiates it.
I was told to instatiate is good practice??
-----Original Message-----
From: Haslett, Andrew [mailto:andrew.haslett@i...]
Sent: Wednesday, 27 February 2002 2:34 PM
To: Access
Subject: [access] RE: ActiveX Component can't create object
<guess>
Why would you use:
set rs = New Recordset
Don't use just Dim it and then assign it?
eg.
Dim rs As Recordset
set rs = db.OpenRecordset(whatever)
</guess>
-----Original Message-----
From: stephen [mailto:stephen@v...]
Sent: Wednesday, 27 February 2002 11:38 AM
To: Access
Subject: [access] ActiveX Component can't create object
Hi, I am trying to run the following code:
Dim rs As Recordset
Set rs = New Recordset
On a windows 98 computer with access 200 just installed on it.
I get the error message:
Err. ActiveX Component can't create object.
I have the latest dll's installed and refferenced so i cannot understand
why this would happen?
Any help on this please wouldn be much appreciated as i have already spent
quite sometime trying to firgure this one out.
Kind Regards,
Sephen
Message #17 by "Leo Scott" <leoscott@c...> on Tue, 26 Feb 2002 22:28:01 -0800
|
|
Go on line to Microsoft
http://www.microsoft.com/data/download.htm
you can download any version of MDAC you want and install it.
|-----Original Message-----
|From: Stephen Woods [mailto:stephen@v...]
|Sent: Tuesday, February 26, 2002 8:19 PM
|To: Access
|Subject: [access] RE: ActiveX Component can't create object
|
|
|I am thiking my problem is a result of not having the latest MDAC
|installed.
|(thanks Leo Scott for this lead)
|
|Now i checked the registry on the cpomputer that does work and it
|found MDAC
|version 2.6, then i tried the computer that didnt work and it found MDAC
|version 2.5 in the registry, even after installing Office Service Pack 1.
|
|So somehow i need to get MDAC version 2.6 installed on the client machines.
|And microsoft ssay the only way you can do this is to do the following.
|
|Install a released service pack.
|
|-or-
|
|Run an operating system Web-based update package.
|
|
|So far i have only installed Acess 2000 and Office Service pack 1...
|
|Regards,
|Stephen
|
|-----Original Message-----
|From: Haslett, Andrew [mailto:andrew.haslett@i...]
|Sent: Wednesday, 27 February 2002 2:52 PM
|To: Access
|Subject: [access] RE: ActiveX Component can't create object
|
|
|Think you're probably right.
|
|I do it in ASP (VBScript) when referencing ADO but I guess have been slack
|in access using DAO.
|
|-----Original Message-----
|From: Stephen Woods [mailto:stephen@v...]
|Sent: Wednesday, 27 February 2002 2:13 PM
|To: Access
|Subject: [access] RE: ActiveX Component can't create object
|
|
|I was always told you had to Instatiate your objects.
|
|Even if you dont isntatirate it, when you go to open the recorset or set it
|to something, it then automatically instatiates it.
|
|I was told to instatiate is good practice??
|
|
|
|-----Original Message-----
|From: Haslett, Andrew [mailto:andrew.haslett@i...]
|Sent: Wednesday, 27 February 2002 2:34 PM
|To: Access
|Subject: [access] RE: ActiveX Component can't create object
|
|
|<guess>
|Why would you use:
| set rs = New Recordset
|
|Don't use just Dim it and then assign it?
|
|eg.
|Dim rs As Recordset
|set rs = db.OpenRecordset(whatever)
|
|</guess>
|
|-----Original Message-----
|From: stephen [mailto:stephen@v...]
|Sent: Wednesday, 27 February 2002 11:38 AM
|To: Access
|Subject: [access] ActiveX Component can't create object
|
|
|Hi, I am trying to run the following code:
|
|
|Dim rs As Recordset
|Set rs = New Recordset
|
|
|On a windows 98 computer with access 200 just installed on it.
|
|I get the error message:
|
|Err. ActiveX Component can't create object.
|
|I have the latest dll's installed and refferenced so i cannot understand
|why this would happen?
|
|Any help on this please wouldn be much appreciated as i have already spent
|quite sometime trying to firgure this one out.
|
|Kind Regards,
|Sephen
|
|
|
|
|
|
|
|
|
|
|
View Cart
