Running ACCESS 2000, sqlserver2005. Ever since we went to this wonderful version of sqlserver2005 problems keep creeping up. I have a few simple reports. The stored procedures which drive them run in under 2 seconds. The report however will not open. They time out. All of these reports pass parameters to the SP's and if not they get prompted for them. Sometimes I hard coded the data (input parameters) and it worked and then I would remove it and I would not work again. We are talking about 100 - 1000 records. Not zillions of records. Like I said, the SP runs fine, it just can't get the data to the report.
Is there maybe another patch I need ?
Remember when... everything worked and there was a reason for it?
Is there maybe another patch I need ?
Remember when... everything worked and there was a reason for it?
