Thanks Adelle for your feedback. The error was caused by the usage of VB reference "Microsoft Remote Data Object 2.0", together with Ms Office 2000. Previously I was using RDO in my program. There is actually a fix tools for this error from Microsft KB.
--- "Adelle L. Hartley" <[EMAIL PROTECTED]> wrote: > Hi, > > Could you please give us the line where the error > occurs? > > In the meantime, you may find the following useful: > http://support.microsoft.com/default.aspx?scid=kb;en-us;239114 > > To connect to an Access 2000 database, you need to > have the Jet engine > (version 4) installed (the engine that Access 2000 > uses to create > databases). > > Does your program use DAO or ADO? If you are using > ADO then you will need > also need to install MDAC (it gets a mention on the > page linked above). > > Adelle. > > > -----Original Message----- > > From: obelix asterix > [mailto:[EMAIL PROTECTED] > > Sent: Friday, 3 September 2004 12:59 > > To: [EMAIL PROTECTED] > > Subject: [vbhelp] Connect Access 2000 using VB5 > > > > Can someone guide me how do I connect to my Access > 2000 > > database using VB5 ? What is the syntax ? > > > > If existingly the Access database was created in > 97, and I am > > using Access 2000, is there a way I can use > > VB5 to connect to my Access 97 ? The reason I > asked is > > because when I run my program, there is a run time > error > > saying "ActiveX component cant create object". > > > > Pls help > > __________________________________ Do you Yahoo!? Y! Messenger - Communicate in real time. Download now. http://messenger.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
