Viewing 15 posts - 106 through 120 (of 123 total)
Try logging on as the account you use to run SQL Server Agent and run the package. If there's a permissions issue, you should see where the process fails.
May 25, 2005 at 5:41 am
You could create a formatted spreadsheet which gets its data from a link to the spreadsheet output by your DTS package. Every time you open your formatted sheet, refresh the...
May 20, 2005 at 2:03 am
No problem. I'm really getting into passthrough queries - I often see a query run up to 10 times faster this way!
Glad to help
May 12, 2005 at 3:09 am
If I were you I'd put the code that amends the querydef in the form where you are entering the costcode. That way your report never has to change, as...
May 12, 2005 at 2:30 am
Paul
That's right. On your form, you could put a command button with code behind it which:
1 Checks that all necessary parameters have been entered and validates them
2 Builds the SQL...
May 11, 2005 at 3:34 am
You could create a passthrough Access query, build up an SQL string according to the parameters on your form and then update the SQL property of the querydef, along the...
May 11, 2005 at 2:34 am
Well I got married last year, so that's one convert!
May 5, 2005 at 11:06 am
It's my life's ambition to prove that everyone loves a smartarse.
May 5, 2005 at 10:01 am
The database cursor is an acronym for CURrent Set Of Records (or Rows). The mouse cursor is derived from the Latin word for "to run" (http://www.etymonline.com/index.php?l=c&p=33) and is an extension...
May 5, 2005 at 2:44 am
Hi Steve. This was the first CTP I'd installed on this machine (or anywhere else, for that matter), although I did have to try installing it several times, so it...
May 4, 2005 at 10:29 am
There is a new series going out on BBC Radio 4 now, based (I believe) on Douglas Adams' original scripts. You can listen to the episodes at http://www.bbc.co.uk/radio4/progs/listenagain.shtml#h but bear...
May 4, 2005 at 2:55 am
Or create a pass-through query in Access with the SQL
SELECT SUSER_SNAME() AS LoginName
You can then read the data from here as with any other query
Scott Doughty
April 27, 2005 at 1:57 am
Is your ODBC connection set to use TCP/IP or has it defaulted to named pipes?
April 22, 2005 at 2:15 am
You could split your Access database into two - one contains static data and the other data which can change. Use linked tables to join them together. Then you only...
March 10, 2005 at 2:43 am
I think I've got almost the full set
Kid's laptop: Win 98 SE
Wife's desktop: Win ME
Work laptop: Win 2000 Pro
My desktop: Dual boot Win XP Pro and Mandrake Linux 10.1
All held...
January 24, 2005 at 6:14 am
Viewing 15 posts - 106 through 120 (of 123 total)