ASP/ASP.net: Web-based JET database management tool?

Question

I need to manipulate some tables in a JET database housed on a web-server:

• check existing indexes
• change table cluster/primary key
• see what tables exist
• rename tables
• add tables
• drop tables
• browse data
• etc

I don't have the option of installing PlaneDisaster or Access (even if i had it) on the local machine.

I've already written a generic web-based query tool. I'd rather not have to get into writing a whole web-based database maintenance GUI. Someone must have done this already, and probably many times over.

Answer 1

As you say you have already done a generic web based query tool. The problem with JET is that you cannot connect with it as database server like you can do with one SQL server in order to process changes to tables and other maintenance procedures. Jet is is not a client/server RDBMS. You need to have an application in the server to do that for you as you already have done with your generic web based tool, or download the database to your machine. That's why you have done some procedures and locate them in the server as asp pages.

Anyway you can use JetSQLConsole, if you don't want to use Planedisaster or Access, but remember that you need always an application on the server to to the job for you

You can also use access "in your machine" and connect to a database located in a URL (http://myserver/mydatabase.mdb) but remember when you are doing this you are downloading all the database and when you save it you are uploading it again.

Answer 2

A partial answer might be Compare'Em http://home.gci.net/~mike-noel/CompareEM-LITE/CompareEMscreens/CompareEM-About.htm The Pro version allows you to create SQL statements to update the Access database file. This will allow you to generate the differences between one version and a newer version.

His website isn't very clear but as I recall the price for the Pro version was $10.