Excel Queries using Access data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im trying to create a query from within Excel. When I select new database
query and select a database which has no securtiy login/password, no problem,
works fine. However, when I try to source the data from a database which I
have created using user logins/passwords it says that I do not have admin
privilages to use the database even though I am putting in the correct
login/username in the popup window? Please can anyone help?
 
I've had limited experience with this sort of thing but I've always had to
strip out the protection on the Access Database and create a copy before
successfully running the Query............

Vaya con Dios,
Chuck, CABGx3
 

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

Importing Data from Access 2
ODBC Microsoft Access Driver Login Failed 1
External data connection needs separate login for each query 1
Refreshing Excel worksheet with data linked from Access 1
Excel 2007 / MS Query - editing existing query to another sheet 0
Using MS Query with Excel and Access 2007 3
Not all Access queries can be imported 1
External Data Refresh Issues 0

Back
Top