Re: Runtime Error 91
- From: "Daniel Crichton" <msnews@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 18 Oct 2005 09:08:56 +0100
Jean-Philippe wrote on Mon, 17 Oct 2005 16:43:02 -0700:
> Hi
>
> I have a VB6 Application wich connect to an Access 97 database. We have a
> function to connect to the database like this
>
> Dim wrkDefault As Workspace
>
> Set wrkDefault = DBEngine.Workspaces(0)
> Set objDatabase = wrkDefault.OpenDatabase(strConnectionString)
>
> In the references we are using the
>
> It works on all the computer, but today we found a problem with one
> computer. On this computer we have Microsoft Office 2003 with Access 2003
> and Windows XP Home Edition. And each time we try to run the program we
> get the following error :
>
> Runtime Error 91 Object variable or width block not set
>
> and after that
>
> Runtime error 429 : ActiveX cannot create object
>
> Normally when we have this kind of problem we ask our customer to update
> their MDAC and jet version. But this time, it didn't work. The setup
> told me that the version of mdac is already updated.
>
> I checked the version with the MDAC Component Checker, and the version is
> MDAC 2.8 SP1.
>
> I tried to remove Access, make all the windows update. But nothing works.
>
> Can some help me ?
>
> Thanks
Get the customer to install the Jet runtimes. They are no longer part of
MDAC, and I have a feeling Access 2003 doesn't include DAO anymore as it's
OLE DB/ADO based.
You can find the Jet 3.51 SP3 and Jet 4 SP8 downloads at:
http://msdn.microsoft.com/data/downloads/updates/default.aspx#jet
Any particular reason why you haven't switched over to ADO for your
application?
Dan
.
- Prev by Date: Re: Memory Leak with Recordset?
- Next by Date: RE: Discussing 3 different strategies for deleting from multiple table
- Previous by thread: ADO: Excel VBA timeout error
- Next by thread: ADO Error Code[80004005] (Selected collating sequence not supported by the operating system)
- Index(es):
Relevant Pages
|
|
