Looking for some advice on Access and VB.
I have been working with a local non-profit affiliate on the development of a database to automate one of the clinical programs. We finally have a finished product – using a front end/back end – with multiple users entering simultaneously. We have been beta testing with volunteers and all seems to be going well.
My concerns are…
First, as I have been looking around the web at various forums, tech sites and Microsoft access is often referred to as a “toy”, a personal vs. business application, a limited db lacking in power and stability. I do not want to implement this complete change-over from the current manual system to automated if MS Access can’t handle it.
Second, the project has grown from almost a “let’s see if we could do this” to now having the National parent organization showing serious interest in the database. That itself has brought in issues of the capabilities of Access, creating the database as a stand-alone, copyrighting the database, etc.
The only VB experience I have is with access, which I believe is not actually VB but VBA? Many forums have mentioned creating the database in VB, which is more of a powerhouse and stable format. Some have mentioned using the Office XP Microsoft Office XP 2002 Developer Edition. I do not want to mislead this organization or on the other hand – restrict any possibilities based on my limited knowledge.
Thanks for your time helping out this amateur.
I have been working with a local non-profit affiliate on the development of a database to automate one of the clinical programs. We finally have a finished product – using a front end/back end – with multiple users entering simultaneously. We have been beta testing with volunteers and all seems to be going well.
My concerns are…
First, as I have been looking around the web at various forums, tech sites and Microsoft access is often referred to as a “toy”, a personal vs. business application, a limited db lacking in power and stability. I do not want to implement this complete change-over from the current manual system to automated if MS Access can’t handle it.
Second, the project has grown from almost a “let’s see if we could do this” to now having the National parent organization showing serious interest in the database. That itself has brought in issues of the capabilities of Access, creating the database as a stand-alone, copyrighting the database, etc.
The only VB experience I have is with access, which I believe is not actually VB but VBA? Many forums have mentioned creating the database in VB, which is more of a powerhouse and stable format. Some have mentioned using the Office XP Microsoft Office XP 2002 Developer Edition. I do not want to mislead this organization or on the other hand – restrict any possibilities based on my limited knowledge.
Thanks for your time helping out this amateur.