Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set Nocount On or equivalent for Access2000

Status
Not open for further replies.
nexcar

nexcar

Programmer
Jun 30, 2003
49
US
I'm writing an app in vb6 that uses an Access 2000 db to store info. When running a stored procedure and trying to put the results into an ADO recordset, the EOF flag is always TRUE. I had similiar problems on some SQL projects until I found the wonderful command SET NOCOUNT ON. I use it in all my stored procedures now. Is there an access equivalent to that command? OR is there some way to do this? I know how to use ADO with SQL very well, its just that I'm having issues with using Access.


set MyRS = DB.Execute("EXEC MyStoredProc")

Thanks,
 
Status
Not open for further replies.

Similar threads

PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
262
PizMac
PizMac
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
599
TheresAlwaysAWay
TheresAlwaysAWay
ameedoo3000
  • Locked
  • Question
format partition by vba code
Replies
6
Views
375
mattKnight
mattKnight
renigar
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
361
renigar
renigar
LondonJohn
  • Locked
  • Question
Problem using Access 2003 and 2007 for the same database
Replies
4
Views
249
LondonJohn
LondonJohn

Part and Inventory Search

Sponsor

Back
Top