M
Matthew Tisdel
I have tried linking to a number of SQL views, and they all have the same
problem in Access when I attempt to return * from the view. The view that I
am really attempting to get working, has 6500 entries of 20 columns.
They will return everything in the query in about 1.5 minutes when I hit the
"!" and it works fine when I tell it to let me see the last record that it
found. However, when I attempt to send everything to the clipboard, or I
attempt to send it all to Excel, then Access locks up. The status bar says
"Copy in progress," but it gets stuck at one bar and stays there. I have let
it run for up to 2 hours and it never moves. I have tried on a multiple
machines and I get the same results. I have created multiple access files and
that did not help.
Any ideas on this?
problem in Access when I attempt to return * from the view. The view that I
am really attempting to get working, has 6500 entries of 20 columns.
They will return everything in the query in about 1.5 minutes when I hit the
"!" and it works fine when I tell it to let me see the last record that it
found. However, when I attempt to send everything to the clipboard, or I
attempt to send it all to Excel, then Access locks up. The status bar says
"Copy in progress," but it gets stuck at one bar and stays there. I have let
it run for up to 2 hours and it never moves. I have tried on a multiple
machines and I get the same results. I have created multiple access files and
that did not help.
Any ideas on this?