I want to create an online database on my website, one that can be updated instantly by visitors. The database doesn't need to be large. The number of users would only need to be 500 per day. Any ideas of how to do this easily???
Printable View
I want to create an online database on my website, one that can be updated instantly by visitors. The database doesn't need to be large. The number of users would only need to be 500 per day. Any ideas of how to do this easily???
You could use client side script with DHTML to do it instantly, but this would leave you open to attack from hackers. Best to keep your data Access to server side processing.
To do this, you would be best to write your web site using ASP, using a SQL Server database instead of Access. The SQL Server will allow a greater number of concurrent connections than the Access database, and is more secure for internet usage.
The ASP pages could use a Com component (ActiveX DLL) to do all the database work, SELECT, INSERT, UPDATE and DELETE. This allows you to keep all your code away from the page delivery system.
If you are going to use SQL2000 for the database then I reccommend writing stored procedures which can export XML streams. This can then be transformed with XSLT to deliver pages direct to the user without much ASP work at all.
Your best bet is to look up these new technologies on the MSDN website, as you will be surprised, once you have started using them, they are likely to change your outlook on web page delivery.
:cool: