topic Re: A2k VBA's DAO in VBA Forum

A2k VBA's DAO

Anonymous — Thu, 26 Oct 2000 18:49:04 GMT

Ok, I have my app working great (for the most part.) After installing on
many systems with A2Ki, I find that it does not work on computers which had
never had Office installed on it.

It crashes on... Set MyDB = OpenDatabase("c:\data\file.mdb") ...with an
"Execution Error" message.

How can I get my app to work with out installing office?
Any suggestions?

Re: A2k VBA's DAO

Anonymous — Thu, 26 Oct 2000 19:37:19 GMT

You may want to try downloading Microsoft's Data Access Components (MDAC).
Go to www.microsoft.com/data and start from there. The current version is
2.6. This usually takes care of data access problems that I have.

~ Tom

"Omar Melo" wrote in message
news:F2E548994ED3BC92F3AAF63F6BBCF20B@in.WebX.SaUCah8kaAW...
> Ok, I have my app working great (for the most part.) After installing on
> many systems with A2Ki, I find that it does not work on computers which
had
> never had Office installed on it.
>
> It crashes on... Set MyDB = OpenDatabase("c:\data\file.mdb") ...with an
> "Execution Error" message.
>
> How can I get my app to work with out installing office?
> Any suggestions?
>

Re: A2k VBA's DAO

Anonymous — Thu, 26 Oct 2000 19:40:12 GMT

Could you use an On Error Resume Next statement just above your
OpenDatabase statement and look at the error collection to get the
error number and possibly a better description?

- Tom

Omar Melo wrote in message
news:F2E548994ED3BC92F3AAF63F6BBCF20B@in.WebX.SaUCah8kaAW...
> Ok, I have my app working great (for the most part.) After
installing on
> many systems with A2Ki, I find that it does not work on computers
which had
> never had Office installed on it.
>
> It crashes on... Set MyDB = OpenDatabase("c:\data\file.mdb") ...with
an
> "Execution Error" message.
>
> How can I get my app to work with out installing office?
> Any suggestions?
>

Re:

Anonymous — Thu, 26 Oct 2000 19:59:51 GMT

mdac will not work on W2K because the files that it tries to install
are protected by the OS. On restart, the originals are restored. In
order to get DAO 3.6 on a W2K machine, you need to install SP1.

- Tom

Thomas W. Gallup wrote in message
news:E870B632EECE42FF6512886F1ADA061A@in.WebX.SaUCah8kaAW...
> You may want to try downloading Microsoft's Data Access Components
(MDAC).
> Go to www.microsoft.com/data and start from there. The current
version is
> 2.6. This usually takes care of data access problems that I have.
>
> ~ Tom

Re:

Anonymous — Thu, 26 Oct 2000 20:00:15 GMT

Err=429
Description= ActiveX component can't create object

Dowwwwnloading Microsoft's Data Access Components as suggested.

"Tom Gilmer" wrote in message
news:87F282C78BB8588C3D1D3484AC5947A9@in.WebX.SaUCah8kaAW...
> Could you use an On Error Resume Next statement just above your
> OpenDatabase statement and look at the error collection to get the
> error number and possibly a better description?
>
> - Tom
>
> Omar Melo wrote in message
> news:F2E548994ED3BC92F3AAF63F6BBCF20B@in.WebX.SaUCah8kaAW...
> > Ok, I have my app working great (for the most part.) After
> installing on
> > many systems with A2Ki, I find that it does not work on computers
> which had
> > never had Office installed on it.
> >
> > It crashes on... Set MyDB = OpenDatabase("c:\data\file.mdb") ...with
> an
> > "Execution Error" message.
> >
> > How can I get my app to work with out installing office?
> > Any suggestions?
> >
>

Re:

Anonymous — Thu, 26 Oct 2000 20:15:24 GMT

Disregard what I said about mdac as it does not apply to mdac 2.6 on
W2K.
- Tom

Tom Gilmer wrote in message
news:DE3C94B3CDD75302823FFE682EC8F68B@in.WebX.SaUCah8kaAW...
> mdac will not work on W2K because the files that it tries to install
> are protected by the OS. On restart, the originals are restored. In
> order to get DAO 3.6 on a W2K machine, you need to install SP1.
>
> - Tom

Re:

Anonymous — Thu, 26 Oct 2000 20:31:33 GMT

That is what I was thinking. 2.6 is installed off the CD with Win2K.

~ Tom

"Tom Gilmer" wrote in message
news:4012988BB81F398848A518D2607A00C8@in.WebX.SaUCah8kaAW...
> Disregard what I said about mdac as it does not apply to mdac 2.6 on
> W2K.
> - Tom
>
> Tom Gilmer wrote in message
> news:DE3C94B3CDD75302823FFE682EC8F68B@in.WebX.SaUCah8kaAW...
> > mdac will not work on W2K because the files that it tries to install
> > are protected by the OS. On restart, the originals are restored. In
> > order to get DAO 3.6 on a W2K machine, you need to install SP1.
> >
> > - Tom
>

Re:

Anonymous — Fri, 27 Oct 2000 15:18:29 GMT

W2K SP1 did not help. I'm checking out other avenues related to SPs.

I'm using the DAO2535.tlb for better or worse.

I would use DAO 3.6 if I could find adequate the help files or examples to
figure out how to get it to work with what I have.

As I mentioned to another posting, the exact error is 429:ActiveX component
can't create object if that is of any use.

Thanks for the suggestions.

"Tom Gilmer" wrote in message
news:DE3C94B3CDD75302823FFE682EC8F68B@in.WebX.SaUCah8kaAW...
> mdac will not work on W2K because the files that it tries to install
> are protected by the OS. On restart, the originals are restored. In
> order to get DAO 3.6 on a W2K machine, you need to install SP1.
>
> - Tom
>
> Thomas W. Gallup wrote in message
> news:E870B632EECE42FF6512886F1ADA061A@in.WebX.SaUCah8kaAW...
> > You may want to try downloading Microsoft's Data Access Components
> (MDAC).
> > Go to www.microsoft.com/data and start from there. The current
> version is
> > 2.6. This usually takes care of data access problems that I have.
> >
> > ~ Tom
>

Re:

Anonymous — Thu, 02 Nov 2000 18:24:00 GMT

what about using 32 Bit ODBC to configure your database
Omar Melo wrote in message
news:A7F27E0F54105C4B67F7B8B63850BEF0@in.WebX.SaUCah8kaAW...
> Err=429
> Description= ActiveX component can't create object
>
> Dowwwwnloading Microsoft's Data Access Components as suggested.
>
> "Tom Gilmer" wrote in message
> news:87F282C78BB8588C3D1D3484AC5947A9@in.WebX.SaUCah8kaAW...
> > Could you use an On Error Resume Next statement just above your
> > OpenDatabase statement and look at the error collection to get the
> > error number and possibly a better description?
> >
> > - Tom
> >
> > Omar Melo wrote in message
> > news:F2E548994ED3BC92F3AAF63F6BBCF20B@in.WebX.SaUCah8kaAW...
> > > Ok, I have my app working great (for the most part.) After
> > installing on
> > > many systems with A2Ki, I find that it does not work on computers
> > which had
> > > never had Office installed on it.
> > >
> > > It crashes on... Set MyDB = OpenDatabase("c:\data\file.mdb") ...with
> > an
> > > "Execution Error" message.
> > >
> > > How can I get my app to work with out installing office?
> > > Any suggestions?
> > >
> >
>