Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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 "baconroll" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
New Excel data does not appear in linked Access table | Excel Discussion (Misc queries) | |||
Can excel sort entire rows of data like access? | Excel Worksheet Functions | |||
Paste Access data into Excel spreadsheet | Excel Discussion (Misc queries) | |||
MS Excel data reading in MS Access | Excel Discussion (Misc queries) | |||
Layout/Formatting problems of Data Queries in Excel? | Excel Discussion (Misc queries) |