It has been years since I have done any programming or work with databases, all of which was done in Paradox (4.0 & 5.0) and the Windows 3.1 environment. My new task at had is selecting a development environment and database solution for a project. The makeup of this database will really not be extremely complex (15-20 tables). In attempting to get up to speed with technology changes in programming & databases, I am finding that for the most part the BDE is being abandoned and SQL/Web-solutions/.NET are here/replacing older database solutions.
One option “seems” to be using Access as a development environment, but I was leaning towards Delphi 7/8 which leaves the choice of a database solution up in the air. Mainly I am asking for advice on what type of database/development platform to use. Our work environment consists of Windows XP machines and Windows Server 2003 (w/SQL Server 2000). The final application/database will probably need to be client/server, although very few users will ever access the database simultaneously (maybe 4-8). The data, due to government regulations, would eventually need to be backed up and easily accessible for 7 years, but the application/database would not be distributed to a large user base (10 people max).
I don’t really know much about .NET, ASP etc, and whether that is something I should investigate/consider more either. Any advice/direction appreciated with regard to Delphi and Database solutions.