Conversion of Access Database Systems to Visual Basic Dot NET and SQL Server
Microsoft Access is showing its age. Most of the techniques (File Server, VBA, DAO, Jet Database Engine, etc) hark back 20 or more years. Microsoft will continue supporting VBA for many years to come, but the programming emphasis is rapidly changing in favour of Visual Basic.Net and SQL Server. For company administration systems, the combination of a VB.Net FrontEnd with an SQL Server BackEnd database is the ideal. Visual Basic is business rules oriented and SQL Server is efficient and easy to maintain. VB.Net Upgrade Conversion Reasons The reasons for an upgrade from Microsoft Access to Visual Basic.Net and an SQL Server database are: A strategic corporate decision A worry about the future of Visual Basic for Applications (VBA) The difficulty and cost in supporting obsolete and error ridden code The difficulty and cost in supporting code written by amateurs without regard to standards The need to replace an inefficient administration system that just “grew like Topsy” The n...