Managing database content

[kjs50]

Hello,

I've created a custom database in Access that contains all the data for my site. I've created many fields to be able to fully customize my pages and then generate static html pages from the data using a php script.

My question is what tools are out there that can allow me to better maintain my content in the database. I would prefer something php based. I would like something that I can point at my different database fields and can automatically generate the web form to edit and add records. I can create a form in Access, but would prefer something web based in case I ever switch to MySQL later on.

I've looked at some of the main CMS systems out there, but it looks like they work with their own architecture and I would have to do great modification to work with a different database schema.

Thanks.

[timchuma]

Probably the best solution would be to set up some intranet pages that allow you to maintain the website database internally.

I have done this for my company using SQL Server and ASP, as it was the easiest for me to do at the time.

Thanks.