[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Access Macro Import

Posted on 2009-04-27
4
Medium Priority
?
192 Views
Last Modified: 2013-11-27
I am creating a Macro, with Transfer.Spreadsheet, Import.

I have entered all the required information, including the path of the Excel file to be imported. When I attempt to execute, I get this message "Operation Must Use an Updateable Query."

1. It does not make sense why thie Macro cannot run stand alone, and why a Query is needed.
2. If a query is definitely needed, please confirm the code/query to be used

Thanks.  
0
Comment
Question by:tahirih
  • 3
4 Comments
 
LVL 5

Accepted Solution

by:
Aanvik earned 2000 total points
ID: 24245783
This looks like a permission issue. Look at this article and apply the same changes in your macro.

http://support.microsoft.com/kb/175168
0
 

Author Comment

by:tahirih
ID: 24245847
I have read through this. How can I resolve it?

Thanks.
0
 

Author Comment

by:tahirih
ID: 24245975
I have attempted to fix this unsuccessfully. Please advise. Thanks.
0
 

Author Closing Comment

by:tahirih
ID: 31575203
Thanks
0

Featured Post

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.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
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…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

834 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