I looked at these and don't seem to be using the right options. The best I was able to do was 4.8GB.

I had to got the MS support on this and basically you can use setspn to register the account

From BOL:

Adding an SPN to SQL Server

To add an SPN on...

Thanks John,

This is alot more concise and does use the strength of a relational DB instead of the repetitive looping of simplistic code.

I appreciate your response.

I was able to figure it out. Here's what I used if you are interested:

DECLARE @TRACK as char(10)

DECLARE FBROW CURSOR FOR

 SELECT FEEDBACK.TRACKING_ID FROM FEEDBACK WHERE FEEDBACK.STATUS = 'CLOSED'

OPEN FBROW

FETCH NEXT...

VBA Forum

http://www.utteraccess.com

Not exclusively VBA but a good source of info. Like one of the previous posters suggested using Excel Macro recorder is a good way to pick up some...

Perfect!

ISNULL was the option I was looking for, the same as an IIF in VB. I also did not know that you had to have the whole ISNULL phrase...

I have started bypassing Access when my end result is getting data into an Excel spreadsheet. Here is a bit of VBA code I put into an Excel template. The...