sofiansafy
asked on
Recordset error message
I have this error message when I try to create a Recordset
( Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object )
( Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object )
You may not have MDAC installed.
http://www.microsoft.com/data/download.htm
MCM and I would recommend 2.6 with SP1 :)
http://www.microsoft.com/data/download.htm
MCM and I would recommend 2.6 with SP1 :)
:)
ASKER
MCM
my code is already like your code , and the error
is still occure..
my code is already like your code , and the error
is still occure..
can you make other ADODB objects, such as a Connection? i would try installing the latest MDAC, as Dave suggested, and giving it another go.
ASKER
MCM
Yes I can make a Connection, the problem is with Recordset
....
Dave
I using Microsoft Access97 as a Database(Not SQL200) ,so is MDAC 2.6 SP1 is suitable for me.
Thanks
Yes I can make a Connection, the problem is with Recordset
....
Dave
I using Microsoft Access97 as a Database(Not SQL200) ,so is MDAC 2.6 SP1 is suitable for me.
Thanks
Let me double check...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I don't know how to thank u Dave , its really solve the problem .....
My thanks also to MCM for his care...
Sofian
My thanks also to MCM for his care...
Sofian
You're welcome, glad we could help!
Cya round
Dave
Cya round
Dave
set rs = Server.CreateObject("ADODB