Ok, apparently SQL is preferred by knowledgeable application developers.
I am currently revamping the website for my employer. The site was originally designed by a third-party design firm. They then provided all the files on a CD.
The current setup uses ASP pages with the data stored in an Access Database. This is the setup I’ve been learning to work with.
They did however, provide a folder with a SQL version of the website. There seem to be only minor differences between the two setups.
The biggest one is that the SQL data is stored in an Excel file rather than a database.
As for the ASP pages the coding is very similar. Obviously it has to refer to a different data file and type, but the recordset commands and layout are almost the same as with the Access DB.
There are couple of places where the SQL version seems to have less code, but other than that there is no real apparent advantages [i](at least to my inexperienced eye)[/i]
The future plans for the website are to allow customers to login and access specific pages, some of which may actually be specific only to them.
Am I alright to stay with the Access DB and ASP pages? or should I switch over to the SQL setup?
