Viewing 15 posts - 4,321 through 4,335 (of 6,216 total)
Depending on your final goal, it might make sense to continue to use ADO for this rather than ADO.Net.
Andy
May 8, 2002 at 5:20 am
Just this line should do it:
Orientation = xlLandscape
Now you just need to open the workbook via code, set for the first (only) sheet? Something close to this (off the cuff,...
May 7, 2002 at 6:27 pm
Try recording a macro in Excel while you do the task, then look at the generated code. I imagine you'll have to open the workbook through automation and set a...
May 7, 2002 at 4:27 pm
Seems interesting. Are you sure the .bak file will expand back to 6.9g? Maybe it was backed up prior to the db being shrunk and that accounts for the problem?
Andy
May 7, 2002 at 4:25 pm
Assuming its in a transaction, you could set a trigger to rollback any insert over x rows! Or maybe only give them insert on a staging table so you can...
May 7, 2002 at 2:21 pm
Thats correct. The image size is variable up to the max size of the field, pointer is always 16 bytes. The exception is with SQL2K if you have enabled the...
May 7, 2002 at 1:53 pm
If/when you move the mdf the issues are about the same. If you already have the logins on the new server you'll have to change the SID's using sp_change_users_login -...
May 7, 2002 at 1:51 pm
There is a readall method which is faster (think set based vs cursor). In some cases you find it faster to use the older Vb Open style file access. I...
May 7, 2002 at 1:49 pm
I use QA, though I long for intellisense for object names! Possibly in Yukon.
Andy
May 7, 2002 at 1:08 pm
If you get time to investigate more would make a great article (or two).
Andy
May 7, 2002 at 11:01 am
A technique pretty similar would be to use set rowcount to create a temp table with the x number of rows, then include the temp table in your query -...
May 7, 2002 at 10:56 am
I think you'll find the book helpful. Unfortuneately it always comes down to having to test your theories, even if based on the book!
Antares, I find the info about the...
May 7, 2002 at 6:18 am
I know that I have gotten merge replication between SQL and Access to work, so even if you can't get transactional to work you could go with this. MDB was...
May 7, 2002 at 6:10 am
Looks ok - maybe the params collection is not getting set to nothing, ending up with extra params? Just a guess.
Andy
May 6, 2002 at 7:01 pm
Viewing 15 posts - 4,321 through 4,335 (of 6,216 total)