?
Solved

Microsoft Query

Posted on 2010-08-28
8
Medium Priority
?
589 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 

Author Comment

by:mato01
ID: 33551580
Microsoft Excel  2007 Microsoft Query no longer recognizes accdb files,  Do I need to reinstall Microsoft 2007
0
 
LVL 6

Accepted Solution

by:
radnbne earned 1000 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

743 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