ACCESS FEED: Re: [MS_AccessPros] Copying query runs it first

Selasa, 30 September 2014

Re: [MS_AccessPros] Copying query runs it first

If I want to reinstall Access to see if that will fix the problem completely, what's the best way to do it? Do I need to uninstall and then reinstall my complete Office suite, of can I do just Access? Or maybe doing all of Office would be better, though I haven't noticed any problems with Excel, which I also use regularly.

Any thoughts would be appreciated. Using Access 2010 on Windows 7 Pro.

On Tue, Sep 30, 2014 at 2:30 AM, 'Glenn Lloyd' argeedblu@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Glad I could help James. Workarounds are never ideal but sometimes they do let you get on with the job when a better solution is out of your hands.

Glenn

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, September 29, 2014 10:23 PM

To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Copying query runs it first

That does work, Glenn, so I do have a workaround other than copying the SQL. I did run the office repair, but that didn't seem to fix it completely. Parallels support was no help and blamed it on Microsoft even though I've used Access on Parallels for three years now with no problem at all — until I installed the updated Parallels software a couple of weeks ago. So there's some hitch there. But they will "look into it."

Thanks to you and Bill for helping!

On Mon, Sep 29, 2014 at 4:31 PM, 'Glenn Lloyd' argeedblu@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

What happens if you select the query, then go to the file tab and select Save Object As. If that works you could at the Save Object As to the QAT.

Glenn

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, September 29, 2014 5:22 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Copying query runs it first

Thanks, Glenn. The query is not open, and I'm trying to copy in the Navigation area which shows all Access objects. I either select the desired query and Ctrl-C or else right-click the query and select Copy. Since neither of these approaches no longer works, I'm copying the SQL and pasting into a new query.

On Mon, Sep 29, 2014 at 3:57 PM, 'Glenn Lloyd' argeedblu@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

James,

Are you copying on the navigation bar? Or do you have the query open when you try to copy it?

Glenn

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, September 29, 2014 3:21 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Copying query runs it first

I'm having a new problem with Access 2010 on Windows 7 Professional, and I don't know what I might have done to cause it.

Whenever I try to copy and paste a query in order to duplicate it, Access pauses for a while and is non-responsive. What it is doing is actually running the query and copying the results to the clipboard. When Access becomes responsive again, the query results, if they are small enough, are on the clipboard instead of the query object that I'm trying to duplicate.

I can copy/paste tables just fine; it's just queries that are troublesome. It makes no difference whether I use Ctrl-C or Copy from the context menu. The results are the same.

I am running Access in a virtual machine (the newParallels Desktop 10) on my Mac. I'm pretty sure that the issue lies there, but I have use previous implementations of Parallels for years with no problem. But before I contact Parallels support, I'd like to confirm that I'm not just doing something stupid in Access!

Thanks for any ideas.

James