There is a slight twist to this because I need to use it in a cursor. I'm not sure how to use the @SQL_TEXT which was developed in the...

Thanks! Creating a union view is a good idea but these tables are imported Access tables provided by the government for integration. Their sources are various OEM vendors...

Thanks for the idea. I definitely concur with limiting the return and was looking for proven ways of accomplishing this. I'm leaning toward returning the keys into an...

And that is the reason I've requested some help here. Your response however was somewhat limited since I would need to implement any alternatives. One problem is the...

Thanks! You recommendations helped me overcome this issue. I wasn't using a priming fetch. Now it works great. Documentation was really spotty and didn't explain the...

I've partially resolved this problem, or at least learned a little more about it. Yesterday the debugger worked when debugging a procedure on the server on my local computer....

I am aware that @@FETCH_STATUS is a global variable, after a while using BOL, and when the nested cursor updates @@FETCH_STATUS to -1 the unnested cursor sadly claims it as...

I checked the path and it may have been able to cause the problem, so I updated it and still got the same error. Then I logged onto a...

I've developed using the Jet engine and SQL Server from Access an Access/ASP front end. You need to determine what your requirements are before you pick ANY database engine....

I agree that there is most probably a delimiter within the text being exported. If you are exporting Access text to Excel then you would probably need to create...

Assuming y is a numeric variable and you do NOT have a field in the QuoteDetails table name QuoteDID, you may have erred by using Quotes.QuoteID = QuoteDetails.QuoteDID. If...

Thanks for your advice. I'll abandon efforts to use the connection object and switch to the command object. You advice saved me from banging my head against the...

Yes, I was aware of the possibility of using the return parameter from an ADODB command object but preferred to use the connection execute command because the rest of the...

A great alternative would be to use ADO code. It's merely a COM library to add to the application and you can then do anything that you could with...

@SimilarBy is a float and the others are ints. You caught me. Thanks! I said it was probably something easy I overlooked.