> I've done some vba coding in an access db, but on one of
> the machines it's beeing used I get an error.
> The error message is:
> "method 'Currentdb' of '_Application' Failed" on the line
> under it says "an automation error"
> I figured there was something wrong with the software on
> the machine, not the db.
> I tried to open an empty db and opened a code module and
> typed "?currentdb.version" in the Immidiate Window. I got
> the same error.
> I've re-installed office and run a chkdsk on the machine
> without any luck.
> This is a little bit frustrating so any help or tips
> would be greatly appreciated.

> Thanks!

> Keir Olsen

>-----Original Message-----
>ACCESS 2000 and 2002 versions both default to the ADO

>library. But your code is wanting to use the DAO

>Basic Editor, click Tools | References, and select DAO

>plan to use the ADO library , deselect it.

>Then disambiguate your code by prefixing Database and

>as so:

>Dim db As DAO.Database, rs As DAO.Recordset
>--
>       Ken Snell
><MS ACCESS MVP>

>> I've done some vba coding in an access db, but on one
of
>> the machines it's beeing used I get an error.
>> The error message is:
>> "method 'Currentdb' of '_Application' Failed" on the
line
>> under it says "an automation error"
>> I figured there was something wrong with the software
on
>> the machine, not the db.
>> I tried to open an empty db and opened a code module
and
>> typed "?currentdb.version" in the Immidiate Window. I
got
>> the same error.
>> I've re-installed office and run a chkdsk on the
machine
>> without any luck.
>> This is a little bit frustrating so any help or tips
>> would be greatly appreciated.

>> Thanks!

>> Keir Olsen

>.

>-----Original Message-----
>ACCESS 2000 and 2002 versions both default to the ADO

>library. But your code is wanting to use the DAO

>Basic Editor, click Tools | References, and select DAO

>plan to use the ADO library , deselect it.

>Then disambiguate your code by prefixing Database and

>as so:

>Dim db As DAO.Database, rs As DAO.Recordset
>--
>       Ken Snell
><MS ACCESS MVP>

>> I've done some vba coding in an access db, but on one
of
>> the machines it's beeing used I get an error.
>> The error message is:
>> "method 'Currentdb' of '_Application' Failed" on the
line
>> under it says "an automation error"
>> I figured there was something wrong with the software
on
>> the machine, not the db.
>> I tried to open an empty db and opened a code module
and
>> typed "?currentdb.version" in the Immidiate Window. I
got
>> the same error.
>> I've re-installed office and run a chkdsk on the
machine
>> without any luck.
>> This is a little bit frustrating so any help or tips
>> would be greatly appreciated.

>> Thanks!

>> Keir Olsen

>.

> I haven't tried your suggestion, I will tomorrow. Thanks!
> But i'm not sure it's going to work because I have
> already tried removing the references to ADO, just using
> DAO. Another thing, doesn't the "Currentdb"-method
> automaticly call DAO?

> But thanks for your help so far!

> Kind regards

> Keir Olsen

> >-----Original Message-----
> >ACCESS 2000 and 2002 versions both default to the ADO
> library, not the DAO
> >library. But your code is wanting to use the DAO
> library. Open the Visual
> >Basic Editor, click Tools | References, and select DAO
> library. If you don't
> >plan to use the ADO library , deselect it.

> >Then disambiguate your code by prefixing Database and
> Recordset with DAO.,
> >as so:

> >Dim db As DAO.Database, rs As DAO.Recordset
> >--
> >       Ken Snell
> ><MS ACCESS MVP>

> >> I've done some vba coding in an access db, but on one
> of
> >> the machines it's beeing used I get an error.
> >> The error message is:
> >> "method 'Currentdb' of '_Application' Failed" on the
> line
> >> under it says "an automation error"
> >> I figured there was something wrong with the software
> on
> >> the machine, not the db.
> >> I tried to open an empty db and opened a code module
> and
> >> typed "?currentdb.version" in the Immidiate Window. I
> got
> >> the same error.
> >> I've re-installed office and run a chkdsk on the
> machine
> >> without any luck.
> >> This is a little bit frustrating so any help or tips
> >> would be greatly appreciated.

> >> Thanks!

> >> Keir Olsen

> >.

> I did not work.

> I'm thinking the problem lies either in the dao360.dll or
> the Jet DbEngine

> Probably I'll have to format the disk and reinstall win
> and office. The problem is that I just hate it when I
> don't figure out what's wrong...

> Kind Regards

> Keir
> >-----Original Message-----
> >ACCESS 2000 and 2002 versions both default to the ADO
> library, not the DAO
> >library. But your code is wanting to use the DAO
> library. Open the Visual
> >Basic Editor, click Tools | References, and select DAO
> library. If you don't
> >plan to use the ADO library , deselect it.

> >Then disambiguate your code by prefixing Database and
> Recordset with DAO.,
> >as so:

> >Dim db As DAO.Database, rs As DAO.Recordset
> >--
> >       Ken Snell
> ><MS ACCESS MVP>

> >> I've done some vba coding in an access db, but on one
> of
> >> the machines it's beeing used I get an error.
> >> The error message is:
> >> "method 'Currentdb' of '_Application' Failed" on the
> line
> >> under it says "an automation error"
> >> I figured there was something wrong with the software
> on
> >> the machine, not the db.
> >> I tried to open an empty db and opened a code module
> and
> >> typed "?currentdb.version" in the Immidiate Window. I
> got
> >> the same error.
> >> I've re-installed office and run a chkdsk on the
> machine
> >> without any luck.
> >> This is a little bit frustrating so any help or tips
> >> would be greatly appreciated.

> >> Thanks!

> >> Keir Olsen

> >.