Jenny
06-06-2001, 07:29 PM
I'm developing a new web site for my school and would like to change host from the current one to FutureQuest. However, I do have one problem and I would very much welcome any help or guidance.
We would like to introduce an Alumni area and include a password-protected searchable database. This would not be large (maximum of 5000 pupils I would think) and we only intend to add a few fields online (first name, last name, maiden name, years at school, e-mail address). Although I am confident when it comes to coding web sites, databases are an unknown area to me (except for very simple stuff) and I certainly do not want to get into programming at this point - it's probably completely beyond me anyway. The main school database is an Access document housed in the school office. This contains more fields (such as addresses) that we need to keep private, and we also need to comply with the UK Data Protection Act of course. So, this main database will be kept separate from the online one at least for the time being, though maybe they will need to be linked in the future.
So, to my query:
Can a simple Access database of the kind detailed above be easily converted into or communicate with the PHP/MySQL system that FutureQuest uses?
Or, given my complete newbie status in this area and the fact that the current host has just started to offer a Microsoft Access Database option for $60 (£40) per annum, should I leave this particular web site with the current host?
The latter option would be shame as FQ would suit us best in every other way :)!
We would like to introduce an Alumni area and include a password-protected searchable database. This would not be large (maximum of 5000 pupils I would think) and we only intend to add a few fields online (first name, last name, maiden name, years at school, e-mail address). Although I am confident when it comes to coding web sites, databases are an unknown area to me (except for very simple stuff) and I certainly do not want to get into programming at this point - it's probably completely beyond me anyway. The main school database is an Access document housed in the school office. This contains more fields (such as addresses) that we need to keep private, and we also need to comply with the UK Data Protection Act of course. So, this main database will be kept separate from the online one at least for the time being, though maybe they will need to be linked in the future.
So, to my query:
Can a simple Access database of the kind detailed above be easily converted into or communicate with the PHP/MySQL system that FutureQuest uses?
Or, given my complete newbie status in this area and the fact that the current host has just started to offer a Microsoft Access Database option for $60 (£40) per annum, should I leave this particular web site with the current host?
The latter option would be shame as FQ would suit us best in every other way :)!