Need remote or web-based MS Access SQL tool (e.g. similar to PhpMyAdmin, but ColdFusion-based)

I've been looking all over the web fo开发者_运维知识库r a ColdFusion-based SQL administration tool for Microsoft Access and I can't find one that's simple, free and allows running SQL statements. Any suggestions?

---

Thanks for the recommends, guys, I'll try SQLSurfer. (MSSSME won't work for me.)

"DISCLAIMER: Using MS Access in a (web based) production environment is not recommended."

I understand that, and part of my timeline for this website is to migrate the database to MySQL on our server.

My primary interest in this is to be able to fool around with SQL commands LOCALLY so I can modify some tables. I wouldn't use this in a production environment anyway, especially not one that already has MySQL admin (Don't worry, I have plenty of backups in case I screw something up).

---

DISCLAIMER: Using MS Access in a (web based) production environment is not recommended.

That said, I have to admit that there are projects, customers, etc. where you can't get around having to deal with MS Access Databases the one or other way.

There is an Open Source project on RIAForge, called SQLSurfer which is a web-based ad-hoc query tool powered by ColdFusion. It is a simple way to execute SQL statements on your database (not restricted to MS Access). http://sqlsurfer.riaforge.org/ Actually there is no download link, but you can still get the code from SVN repo. http://svn.riaforge.org/sqlsurfer/

I have been working with an earlier version for a long time and I find it useful for executing prepared SQL statements. It is a very dangerous tool, especially in production, so I'd strictly recommend to include it in a password protected administration environment and deny public access.

---

Can RDS satisfy your needs? works with CFEclipse / CFBuilder.

---

Take a look at SQL Server Management Studio Express - though I've not used it with MS Access, so can't guarantee it'll work.

Hopefully someone more experienced with the two can come along and give more details.

---

You can easily make one your self.

On Adobe's website you can find at least 5 of those tutorials Here's one http://www.adobe.com/devnet/flex/articles/f4cf_firstapp_part1.html which uses Apache Derby, similar to MS Access.

Of course you need to think some things through, like authentication, making some field for writting SQL statement which is going to be sent as cfquery, but it should be a nice experience to make you'r own "phpMyAdmin" ;)

---

For MySQL there is CFMyAdmin.com. It might connect or could be adapted to tonnect to MS Access as well. I agree with Henry though, I'd set up the DSN for your access database, the RDS conection in CFBuilder and then use the query tool.

Other alternatives might be Lita (Mac based), or a FireFox add on like Sqlite Manager. They may surprise you as to what they can open.

Also, Charlie Arehart has a long list of CF based SQL Query tools. Maybe one of them could help: http://www.carehart.org/cf411/#query

Good luck