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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.