agreed, a pivot table in Excel would be easier, but I'm providing the data ready to go to the client, and I don't want them to have to process an...

Heres some sample ActiveX code that I used for changing an Access DB connection, but you could easily use it for your Excel connection:

'Rename the destination Access DB to the...

I've done some work with VB and DTS - within your VB code, specify your SQL database, and your SQL user name and password (or NT authentication if your security...

Have the same problem myself.

Trace Flags didn't work either...

Microsoft state that this is a restriction due to ODBC links:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q275583

They suggest using OLEDB or rewriting your ADO app to...

I can confirm that MSDE supports XML coding same as SQL, which is good.

We're looking at alternatives to using replication (ie, XML) in order to ensure long life for the...

Yes, site autonomy is important in this scenario, so merge replication is very preferable.

I've found quite a bit on MSDE for use on mobile computers on the backend, which is...

I'm trying to do merge replication with an Access 97 database.

My problem extends from the fact that I don't quite understand how to setup the Access DB as a subscriber....

Interesting....

I understand that cursors are quite resource intensive, and avoid them when possible; however it's nice to have as a backstop.

I'm not above learning something new, so I thought I'd...

No, thats just it.

The package (which is executed by the user)is creating an output file (server-wise), which I would like to transfer to the user's PC when finished (or alternatively...

That would be a bit hard for the disconnected sales reps out on the road to interact with. 🙂

I found a way around the problem - I simply applied precedence...

Therefore, I should run my optimisations job (which rebuild indexes) before the shrink database job? That would certainly explain why my database hasn't been shrinking.

No, thats ok. By default I usually check the web, thus got mislead on the /A flag. I have SQL 7 BOL, and though it didn't state it there, I...

cheers,

gave the max date a whirl, but it was still going after 2 hours, so not much benefit there.

I tried a cumulative option, but it's harder than I first thought,...

I've tried different indexes with little result. A cluster index isn't really going to help, considering that the history table is updated daily with 5000+ records.

I don't particularly like "Not...

hmmm...give this a try.

You've setup your NT domain account under the SQL Server agent (and stopped and restarted the service).

Add the NT domain account to SQL Login security, and add...