Hi Guys,
I'd like to get your opinions on something. I have had to resort to working directly with my SQL Server database instead of using linked tables in Access. I'm now designing a VB.Net form to replace my Access form. My question is this, I have a collection of code stored in an Access module. Some of these subs and functions are stand-alones that I execute on the fly and others are used at various points by my form. This code will also be used in the VB.Net form as well. I am wondering what you think would be the best way to incorporate this collection of code into my project. I was actually considering trying to store some of the code in the database as stored procedures and UDFs like my Key Gen and Parse Word functions as well as writing simple stored procedures for Add Update and Delete. I have also considered writing a basic DAL for my form. What are your thoughts?