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
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