>What you are doing should work unless the ConnectHandle is wrong. Does cursorgetprop('connecthandle') return the same value as your toaccess variable? You can also use DBGetProp('connection_name','connection','asynchronous') tp see what it is in the DBC.
>
>I would also make sure FetchSize and MaxRecords to -1 [use DBGet/SetProp].

Thanks for the help, Mark. I like the "what you are doing should work" part :) At least I'm learning something :) :). I'm going to go check to see if cursorgetprop('connecthandle') returns anything. Like I said, when I put toaccess in the debugger I got Can not evaluate expression
And if I'm understanding you, I should change FetchSize and MaxRecords to -1 and should use the DBSetProp function to do so. I'm presuming FetchSize and MaxRecords being set to -1 will mean that there's no constraint... it will get as much as it can handle? And I should do it within the function instead of the designer becuase there's something obviously wrong with the connection in designer? Does that sound about right?

Thanks again for the help.