Recent content by hbusche

I know nothing about sql, but can build queries in Access using the query design tool. I have built the following two queries that I need to combine into one. I think I need to do a left join, but I can't seem to get the syntax right. When I join the queries I want all of the rows and columns...

Issues to consider: Have you compacted your database recently? It compacts on close, but it happens in every database. What do your co-workers have that you don't e.g. more RAM? We have the exact same specs on our computers. What do you have that your co-workers don't e.g. more applications...

It worked just fine at my old job, and works now for my coworkers. So tips for how to troubleshoot this problem would be very much appreciated.

When it works correctly it is significantly faster.

Is there a reason I shouldn't be able to copy/paste? It is much faster.....

I copy and paste in/out of access to excel regularly and recently it has become painfully slow to copy and paste only in access. Excel and all other programs I have no issue. It isn't a huge number of records, excel has no issue with it. I have cleared the clipboard, restarted, and now I don't...