Security problem

[Phil]

I have security set for an Access 2002 db. I am trying to pull data
into Excel using the "new database connection" option in Excel. I
finally got this to work by creating a new ODBC and setting the correct
login and password needed to connect to the Access db and everything
worked great... but when I tried to do the exact same thing on a
different PC i kept getting the error "Invalid Password". This same pc
has no problem running the Access db normally, so I do not know what
the problem is. Any ideas?

[Keith Wilby]

"Phil" <pb******@gmail.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com...

I have security set for an Access 2002 db. I am trying to pull data
into Excel using the "new database connection" option in Excel. I
finally got this to work by creating a new ODBC and setting the correct
login and password needed to connect to the Access db and everything
worked great... but when I tried to do the exact same thing on a
different PC i kept getting the error "Invalid Password". This same pc
has no problem running the Access db normally, so I do not know what
the problem is. Any ideas?

I suspect the answer to your question might have something to do with the
location of the Workgroup Information File but have you considered pushing
the data into Excel from Access? It would make the password issue go away.

Regards,
Keith.
www.keithwilby.com

[Phil]

Thanks for responding so quickly Keith.
It just happens to be one of those things where it didnt work
yesterday, but when I tried the exact same thing today everything
worked fine.

Thanks again,

Phil

Keith Wilby wrote:

"Phil" <pb******@gmail.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com...

I have security set for an Access 2002 db. I am trying to pull data
into Excel using the "new database connection" option in Excel. I
finally got this to work by creating a new ODBC and setting the correct
login and password needed to connect to the Access db and everything
worked great... but when I tried to do the exact same thing on a
different PC i kept getting the error "Invalid Password". This same pc
has no problem running the Access db normally, so I do not know what
the problem is. Any ideas?

I suspect the answer to your question might have something to do with the
location of the Workgroup Information File but have you considered pushing
the data into Excel from Access? It would make the password issue go away.

Regards,
Keith.
www.keithwilby.com