Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MSQRY32 and Access - security issue

Status
Not open for further replies.
notadba

notadba

MIS
May 28, 2003
154
AU
Hi hope someone can help.

I am trying to create an olap cube using the query wizard in MSQRY32, and am hitting an issue when connecting to password protected access databases.

I have tried connecting directly, however it errors for permissions when connecting, prompts for the user/password then loops through to pick the database, then errors for permissions, prompts for user/password then loops...

We tried creating a DSN source for the database and provided the user/password in the DSN, and we are getting the same issues.

Anyone know a way around this? Using Office 2003.

Thanks in advance
 
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Solved
Excel Unique-Filter issue
Replies
3
Views
275
SkipVought
S
Cpreston
  • Locked
  • Question
Pivot Table Issue
Replies
6
Views
340
Andrzejek
Andrzejek
R
  • Locked
  • Question
Issues with Outlook default account and performance
Replies
0
Views
477
radleymartinez
R
Snirt
  • Locked
  • Question
MS-Office 2013 Excel Issue
Replies
1
Views
294
SkipVought
S
Andrzejek
  • Locked
  • Question
Formula with & and a single quote 2
Replies
4
Views
781
OzFoxy
OzFoxy

Part and Inventory Search

Sponsor

Back
Top