Get Data from a secured Access database

  • Thread starter Thread starter erick-flores
  • Start date Start date
E

erick-flores

Hello all

I am trying to get my data from an MS Access2003 file. My Access
database has permission rights (.mdw). So when I tried to Data>Pivot
Tables>External Data Source>Get Data using Excel and click on the .mdb
file that has my Access database it will not let me open it because of
the permissions. I tried opening the database using the shortcut in the
browse option but it will not work either. Can somebody tell me how to
open this Access secured database? or maybe another way to link my
Access database to Excel

Thank you in advance
 
I tried using my logon (in Excel) that I used to logon to the database
in Access and it did not work. Maybe its another password or something?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problems Obtaining Data 2
Copy and move Access 13 database on laptop to pc with Access 13 0
Getting query data from Access 1
Record-Locking remains open after closing 0
ODBC Microsoft Access Driver Login Failed 1
Changing Database links? 3
Using MS Query with Excel and Access 2007 3
Pivot Table with MS Access as DataSource 1

Back
Top