Hi guys. Although I have some knowledge of programming, i'm kinda new to PHP and mySQL so please excuse me if this is a dumb question.
I have a database that contains client information. This database is currently in MS Access format. From what i have read so far, it should be possible to transfer this data into a mySQL database.
What I then want to do is create a part of my site where customers can log in, and view their details. These details may be fairly extensive, much more than just address, phone number etc - things such as machine configurations and so on are stored there to allow my staff to make decisions when sending products to them.
I would like my clients to be able to alter this information, and obviously save it so that me and my staff have the records at hand. This is basically what we do at the moment - but the clients have to phone up and we then make the changes manually to the database.
Is there a system such as a CMS that will provide this functionality?? (commercial or otherwise) All of the CMS systems that i have looked at seem to be overloaded with features that i do not need, and only seperate areas by either registered/non registered users. It is important that the 'Your details' area is specific to each user, and yet more comprehensive [and customisable!]than simple details such as name, e-mail etc.
Sorry for such a long post....but I have honestly spent hours on google trying to find such a system.......and am starting to think I'm gonna have to code it from the ground up myself.