i am looking for some advice on which database i should use with regards to optimising a web front end. here are few details that may be important!
its for a school database, there are quite a few records (very roughly 50,000). it needs read and write access. i am very happy with access and have done web design with ASP (albeit about 10 years ago). are there any serious downsides to using access? if not i know i am happy this. ideally the software should be free, although we probably have alot of stuff we can use, we have a microsoft server.
yes i think i could probably manage SQL server migration (or mySQL)....i haven't done this before, but how hard can it be right???? :0) i have heard that the integration to mySQL from access is harder than SQL server, so i will probably use SQL server. thank you very much for your advice