Access Macro Import

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.  
tahirihAsked:
Who is Participating?
 
AanvikConnect With a Mentor Commented:
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
 
tahirihAuthor Commented:
I have read through this. How can I resolve it?

Thanks.
0
 
tahirihAuthor Commented:
I have attempted to fix this unsuccessfully. Please advise. Thanks.
0
 
tahirihAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.