Attaching to Access data source via Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Virgil - 28 Jul 2004 01:33 GMT

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.)

Reply to this Message

Joan Wild - 28 Jul 2004 13:58 GMT

> I have a password secured Access 97/2000 database that I'm
> trying to attach to via Excel 97/2000 to make pivot tables,
[quoted text clipped - 6 lines]
> pivot tables using non-secured Access data sources is no
> problem.)

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.

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message

Virgil - 31 Jul 2004 13:32 GMT

>-----Original Message-----
>> I have a password secured Access 97/2000 database that I'm
[quoted text clipped - 15 lines]
>Note though, that when you are finished, you'll want to rejoin the standard
>system.mdw.

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!

Reply to this Message