Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Microsoft Query

Posted on 2010-08-28
8
Medium Priority
?
596 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

604 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