Recent content by tiesto

I've just realised that when I run the pass-through query directly from the Queries pane it is also taking 3-4 mins, it was just showing the results before the query had finished. So my problem is the pass-through query itself running far slower than the exact same thing run in SQL Server.

I have a strange problem which I have not been able to solve after hours and hours of google searching. I have a report in Access 2003 which is based on a pass-through query linked to an SQL Server 2005 database. On a button click I alter the SQL of a saved pass-through query which the report...

Hey all, I'm having a strange problem with a particular pass-through query from Access 2003 to SQL Server Express 2005 suddenly running very slow. It's a stored procedure which I can get to run in about 5 seconds directly on SQL, but it takes at least 3 minutes to run the exact same query via a...

I have a database that tracks invoices, purchases, stock, employees etc. On a continuous form I need to assign a different colour to each line depending on which employee made the sale. I have tried Conditional Formatting but that only allows for up to four colours to be assigned. I need about...