Access Database Web Interface

[nwhorton]

Are there any good tutorials around or an easy way in general for me to create web interfaces for my Access Databases? I looked all over Google, but I couldn't find much except for using the wizard included with Frontpage, which I would prefer not use.

The main purpose of this would be to print the databases in html for administrators to be able to check easily without opening databases, but ideally they would also be able to edit/delete entries or do other common tasks associated with databases all from the web.

Thanks for responses!

[dataguy]

I've never seen a web interface for Access, but I've played around with making one myself years ago. It seems like MS is steering people away from Access on web servers these days and pushing them toward SQL Express. Sorry I can't be of more help.

[nwhorton]

Yeah...Access wouldn't be my first choice either, however when the company I'm working for has existing Access databases they'd like to be able to view on the web I don't have much choice.

I know there is a wizard in FrontPage which will do this, however I'd like to avoid this as we don't use frontpage at all here, so I don't want to define the site in frontpage in case it will cause other problems.

I figure there has to be another way of doing this, short of hand-coding, which would be a major, major pain.

[dataguy]

If you only need to work with the data and not the underlying structure, there is a data grid component from Persits Software that is very versatile. It's a little pricey, but I bought a license for it a few years ago and it worked great for viewing tables and occasionally editing data. I think it's called ASPGrid.

[benlieb]

I've used the odbc functions in php to read to and write from an access database.