Solved

MS Access 2007 - External Data - Access Grayed out

Posted on 2010-09-22
5
655 Views
Last Modified: 2013-11-27
Does anyone know why I can't import from Access - its grayed out.  I've tried this in both 2007 and 2003 versions with it being grayed out in both.

Any ideas
image.png
0
Comment
Question by:keschuster
  • 3
  • 2
5 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33738265
Is this greyed out in all databases, or just this one?

Did this ever work?
0
 

Author Comment

by:keschuster
ID: 33738485
it's in all
and it always worked
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33738572
So it just happened recently...
Are you aware of any Auto-updates being installed?

Is the option greyed out on all computers with Access installed?

Make sure you have all your Service Packs installed for Windows and Office.

I researched this and could find no references to this issue...

Try uninstalling Access/Office, then reinstalling it (making sure to select "Full/Complete" Install)

JeffCoachman
0
 

Accepted Solution

by:
keschuster earned 0 total points
ID: 33738689
I rebooted and all is good - thanks
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33738856
ok
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

929 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

11 Experts available now in Live!

Get 1:1 Help Now