VB6/SQL and Stored procedures - Worth?

[Michel Jr]

Hi,

I'm using VB6 with ADO and SQL 7.
I would like to know if it worth using Stored Procedures to access tables, or it's better to load a RecordSet every time I open my program?

Thanks in advance...

Michel Jr.