Hello,
I am creating a database to hold membership details and have been recommended to use SQL Server 2000 for the database, with C# to create the business library (classes) and forms, a 3 tier application. The forms can then be used as a windows application, on the internet and with web services to update another remote database. I have been told the alternative is to create a database and forms using Access 2000, but this will mean it is limited compared to the other solution.
I need the database to store a few thousand members and to have forms for inputting, the problem is that in a year or so the database needs to be linked to web services for automatic updates with another database.
I'm not sure whether there are any simpler routes or anything in between the 2 totally different options I've been recommended to take.
Any suggestions would be much appreciated!
Thanks!
I am creating a database to hold membership details and have been recommended to use SQL Server 2000 for the database, with C# to create the business library (classes) and forms, a 3 tier application. The forms can then be used as a windows application, on the internet and with web services to update another remote database. I have been told the alternative is to create a database and forms using Access 2000, but this will mean it is limited compared to the other solution.
I need the database to store a few thousand members and to have forms for inputting, the problem is that in a year or so the database needs to be linked to web services for automatic updates with another database.
I'm not sure whether there are any simpler routes or anything in between the 2 totally different options I've been recommended to take.
Any suggestions would be much appreciated!
Thanks!