Posts

Showing posts with the label Net

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

Microsoft Dot NET Vs PHP

Dot NET and PHP are two different web development platforms used for the design of dynamic web pages with database support. As an integrated development environment (IDE), PHP currently leads the market, but the choice between PHP and Microsoft’s .NET comes down to the user’s needs, budget, existing software infrastructure, and expertise. A significant part of PHP’s dominance comes from its open-source (free) availability. .NET requires a license, though Microsoft has made free – albeit limited – versions available for download. As with any open-source product, users must seek support through third parties. The higher cost of .NET also brings full support and documentation, perhaps making it more attractive to neophyte web designers who prefer having a phone number to call when encountering a problem. .NET also possesses the built-in reporting tools most users have come to expect from Microsoft products. Generally speaking, PHP enjoys more flexibility and ...