Search results

Thanks for your input -- I tried all kinds of solutions and eventually discovered that one of the tables appeared to have corrupt data that must have caused the problem. I used Compact and Repair after archiving as much older data as I could. That left about 40 records with ####### instead of...

What would cause Access to suddenly close without warning while busy with a query? No error messages, nothing! The query is a fairly big one that normally takes about 6 minutes to run, but has had no problem with it for a number of years. A new drive used for back-up purposes was recently...

As a marketing data analyst, I frequently work with Access crosstab queries, which I literally copy and paste over into my Excel applications. I would like to be able to automate this process, which would require the data "copied" from the Access crosstab query to be "pasted" into a specific...