Mssql, access and php

[DragonEye]

hi,

I have started development of websites using php and mysql about 3 months ago.

But now i have in fact some questions.
My fist php and mysql driven website was a site that features guitar tabs and chords. It wasn't possible to review submitted items (to filter poor quality items) alone so i had to set up some kind of controlcenter. There i could give everyone certain permissions and let them review newly submitted items without taking security risks.

But I am in fact looking to make some corporate sites now. Many companies in Belgium want to be able to update their pages when necessary. Not the layout but just the text from certain pages. Now i was wondering if i would in fact have to set up the same system as i used with my guitar site.

AND NOW COMES THE QUESTION: Can mssql be edited with access? If that's possible i could make an access database to use with php and let the company edit the text content of the pages through a password protected access database that is stored on their own server. That would save a lot of time i guess. But i was wondering wether it was possible to do such a thing. Until now i have only used mysql and the book that I bought to learn php only mentions php and mysql.

[kwvarga]

why not just put all the content in mysql dbs and then make a seperate control panel for them to browse through mysql and edit them.. look at http://www.hotscripts.com/Detailed/21682.html for an example

[AcRoNym]

make a simple editable db