?
Solved

MS Access 2007 - External Data - Access Grayed out

Posted on 2010-09-22
5
Medium Priority
?
723 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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

571 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