Solved

Microsoft Query

Posted on 2010-08-28
8
541 Views
Last Modified: 2013-11-27
I'm trying to use Microsoft Query in Excel to connect to a Access Database I get the below pop up box.

Login

Data Source
MS Access Database

Authorization
Login Name
Password

Please advise


0
Comment
Question by:mato01
  • 5
  • 3
8 Comments
 
LVL 6

Expert Comment

by:radnbne
ID: 33550965
Can you attach a screen shot of the pop-up ?
0
 

Author Comment

by:mato01
ID: 33551054
Here is a print screen of the error I'm receiving
Error.docx
0
 

Author Comment

by:mato01
ID: 33551277
I found out that I need the OBCD driver for accdb.  Looked on microsoft can't find it.  Do you know where I can locate the driver for accdb.  Only have it for mdb.


MS Access Database....Microsoft Access Driver (*.mdb, *.accdb)
0
 

Author Comment

by:mato01
ID: 33551580
Microsoft Excel  2007 Microsoft Query no longer recognizes accdb files,  Do I need to reinstall Microsoft 2007
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 6

Accepted Solution

by:
radnbne earned 250 total points
ID: 33551600
I have tested a connection using MS Query ok here.  what steps are you taking to connect the database?

The steps I used were as follows:

From the Data Menu
Select From Other Sources
Select From Microsoft Query
Select MS Access Database (if this doesn't exist you need to add it back in...settings  attached)
Click OK
Select the database file to use...then follow the prompts to add the data to your worksheet.



setting1.jpg
0
 

Author Comment

by:mato01
ID: 33551639
I don't have to use this on my work PC; however, this solutions works perfectly.  Thanks
0
 
LVL 6

Expert Comment

by:radnbne
ID: 33551744
So this fixed your problem?
0
 

Author Closing Comment

by:mato01
ID: 33551749
Problem solved.  Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now