Get DAO work without installing Access

Get DAO work without installing Access

Anonymous
Not applicable
348 Views
5 Replies
Message 1 of 6

Get DAO work without installing Access

Anonymous
Not applicable
I think this question is asked a little while ago, but I have not seen an
answer to it.
I'm trying to find out how to install the Dao files on my computer without
the need of installing Access. Just copying the files from the directory
Common Files\Dao and register Dao350.dll does not make it work completely.

I'm still getting an error when I create a Database object with
OpenDataBase:
Run-time error 429
ActiveX component can't create object

On machines with Access installed there's no problem.
Does anyone recoqnize this or has the appropriate way to install Dao?

Regards,
Henk
0 Likes
349 Views
5 Replies
Replies (5)
Message 2 of 6

Anonymous
Not applicable
I'm not too familiar with it, but I think you need to download and install
some stuff from Microsoft. Check into the MDAC downloads. Sorry, but I
don't have a link for it.

Henk Loonstra wrote in message
news:7BA2A36DCE556B288B82D2FB5B6633CF@in.WebX.SaUCah8kaAW...
> I think this question is asked a little while ago, but I have not seen an
> answer to it.
> I'm trying to find out how to install the Dao files on my computer without
> the need of installing Access. Just copying the files from the directory
> Common Files\Dao and register Dao350.dll does not make it work completely.
>
> I'm still getting an error when I create a Database object with
> OpenDataBase:
> Run-time error 429
> ActiveX component can't create object
>
> On machines with Access installed there's no problem.
> Does anyone recoqnize this or has the appropriate way to install Dao?
>
> Regards,
> Henk
>
0 Likes
Message 3 of 6

Anonymous
Not applicable
MS Data Access stuf can be found at http://www.microsoft.com/data/ . If you
are starting a new application, consider using ADO instead of DAO. MS is
dropping support for DAO.
--
John Goodfellow
irtf'nm
use 'microtouch' in address to email

"Henk Loonstra" wrote in message
news:7BA2A36DCE556B288B82D2FB5B6633CF@in.WebX.SaUCah8kaAW...
> I think this question is asked a little while ago, but I have not seen an
> answer to it.
> I'm trying to find out how to install the Dao files on my computer without
> the need of installing Access. Just copying the files from the directory
> Common Files\Dao and register Dao350.dll does not make it work completely.
>
> I'm still getting an error when I create a Database object with
> OpenDataBase:
> Run-time error 429
> ActiveX component can't create object
>
> On machines with Access installed there's no problem.
> Does anyone recoqnize this or has the appropriate way to install Dao?
>
> Regards,
> Henk
>
0 Likes
Message 4 of 6

Anonymous
Not applicable
I looked at the MDAC but couldn't find a solution to my problem (I read a
FAQ about a similar error message using DAO in Excel, but the solution (add
a license-key to the registry) didn't do anything in this case. When I
change to ADO, will I get the same problem again (the installation of Access
or VB5.0/6.0 is still needed)?

Henk
0 Likes
Message 5 of 6

Anonymous
Not applicable
After you install MDAC (MDAC_TYP.EXE) you will be able to work with .MDB
databases without having to install MS-Access. MDAC includes ADO, and
should still (maybe) include DAO. The doc's are included.
--
John Goodfellow
irtf'nm
use 'microtouch' in address to email

"Henk Loonstra" wrote in message
news:872C823343A8324B7AA386ECFF26BB1C@in.WebX.SaUCah8kaAW...
> I looked at the MDAC but couldn't find a solution to my problem (I read a
> FAQ about a similar error message using DAO in Excel, but the solution
(add
> a license-key to the registry) didn't do anything in this case. When I
> change to ADO, will I get the same problem again (the installation of
Access
> or VB5.0/6.0 is still needed)?
>
> Henk
>
0 Likes
Message 6 of 6

Anonymous
Not applicable
Thanks, i will try this.

Happy Newyear
Henk

John Goodfellow schreef in berichtnieuws
D37692174666BDB695D3234F7DF893BC@in.WebX.SaUCah8kaAW...
> After you install MDAC (MDAC_TYP.EXE) you will be able to work with .MDB
> databases without having to install MS-Access. MDAC includes ADO, and
> should still (maybe) include DAO. The doc's are included.
> --
> John Goodfellow
> irtf'nm
> use 'microtouch' in address to email
>
> "Henk Loonstra" wrote in message
> news:872C823343A8324B7AA386ECFF26BB1C@in.WebX.SaUCah8kaAW...
> > I looked at the MDAC but couldn't find a solution to my problem (I read
a
> > FAQ about a similar error message using DAO in Excel, but the solution
> (add
> > a license-key to the registry) didn't do anything in this case. When I
> > change to ADO, will I get the same problem again (the installation of
> Access
> > or VB5.0/6.0 is still needed)?
> >
> > Henk
> >
>
0 Likes