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.

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...

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

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...

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...

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...

Well I got married last year, so that's one convert!

It's my life's ambition to prove that everyone loves a smartarse.

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...

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...

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...

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

Is your ODBC connection set to use TCP/IP or has it defaulted to named pipes?

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...

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...