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!

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

Converting VBA to Stored Procedures

Status
Not open for further replies.

innmedia

Programmer
Joined
Mar 24, 2000
Messages
108
Location
US
Hi,
I have an Access97 app moving up to SQL Server 7. My goal is to re-write all the VBA as stored procedures. My questions are:

Can 'all' of it be converted? - some of the VBA is complex.

How do I pas arguments to the stored procedures? - I see how to do this with ADO, but this is Access97 - only have DAO.

Any other concerns or issues?

Thanks!
- Ken B
 
This is not a complete answer but:
You will probably not be able to convert all your VBA code to stored procedures, but the more you can the better (in general). The two main aims of converting your code to sps are to reduce network traffic (data going to/from your application), and to get your business rules on to the server.
I believe you do have access to ADO with Access 97, but if you don't want to go this route, you can use 'pass through queries'
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top