Attaching to Access data source via Excel

  • Thread starter Thread starter Virgil
  • Start date Start date
V

Virgil

I have a password secured Access 97/2000 database that I'm
trying to attach to via Excel 97/2000 to make pivot tables,
but I can't use any of the database's objects as a data
source, at least no way that I'm aware. I'm assuming that's
caused by Access requiring me to be part of a particular
workgroup (system.mdw) and logged in as a certain user. Am
I correct in the assumption that attaching to an secured
Access data source is impossible in Excel? (BTW, making
pivot tables using non-secured Access data sources is no
problem.)
 
Virgil said:
I have a password secured Access 97/2000 database that I'm
trying to attach to via Excel 97/2000 to make pivot tables,
but I can't use any of the database's objects as a data
source, at least no way that I'm aware. I'm assuming that's
caused by Access requiring me to be part of a particular
workgroup (system.mdw) and logged in as a certain user. Am
I correct in the assumption that attaching to an secured
Access data source is impossible in Excel? (BTW, making
pivot tables using non-secured Access data sources is no
problem.)
Click to expand...

It's been a long time since I looked at this, but I think you can join the
workgroup that secured the database (using Start, Run, wrkgadm.exe), and
then when you attach to the secured Access mdb, there is an opportunity to
provide a username/password that will work.

Note though, that when you are finished, you'll want to rejoin the standard
system.mdw.
 
-----Original Message-----


It's been a long time since I looked at this, but I think you can join the
workgroup that secured the database (using Start, Run, wrkgadm.exe), and
then when you attach to the secured Access mdb, there is an opportunity to
provide a username/password that will work.

Note though, that when you are finished, you'll want to rejoin the standard
system.mdw.

--
Joan Wild
Microsoft Access MVP


.
Nope, Access doesn't request a login prompt when trying to
Click to expand...
attached as a data source via Excel. The only method I
found that works is to export the info to Excel for pivot
table analysis. Joan, thanks for your help! Your reply
was much appreciated!
 
Back
Top