I need to manipulate some tables in a JET database housed on a web-server:
我需要操作驻留在Web服务器上的JET数据库中的一些表:
- 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.
我无法在本地计算机上安装PlaneDisaster或Access(即使我拥有它)。
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.
我已经编写了一个基于Web的通用查询工具。我宁愿不必编写完整的基于Web的数据库维护GUI。有人必须已经这样做了,可能已经多次了。
2 个解决方案
#1
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.
部分答案可能是Compare'Em http://home.gci.net/~mike-noel/CompareEM-LITE/CompareEMscreens/CompareEM-About.htm Pro版本允许您创建SQL语句来更新Access数据库文件。这将允许您生成一个版本和一个较新版本之间的差异。
His website isn't very clear but as I recall the price for the Pro version was $10.
他的网站不是很清楚,但我记得专业版的价格是10美元。
#2
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.
正如您所说,您已经完成了基于Web的通用查询工具。 JET的问题在于您无法像使用一台SQL服务器那样将其作为数据库服务器连接,以便处理对表和其他维护过程的更改。 Jet不是客户端/服务器RDBMS。您需要在服务器中安装一个应用程序,就像您已经使用基于Web的通用工具一样,或者将数据库下载到您的计算机上。这就是为什么你做了一些程序并将它们作为asp页面在服务器中定位的原因。
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
无论如何你可以使用JetSQLConsole,如果你不想使用Planedisaster或Access,但请记住,你总是需要服务器上的一个应用程序来为你工作
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.
您还可以使用“在您的计算机上”访问并连接到位于URL(http://myserver/mydatabase.mdb)中的数据库,但请记住,当您执行此操作时,您正在下载所有数据库,当您保存它时,您再次上传。
#1
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.
部分答案可能是Compare'Em http://home.gci.net/~mike-noel/CompareEM-LITE/CompareEMscreens/CompareEM-About.htm Pro版本允许您创建SQL语句来更新Access数据库文件。这将允许您生成一个版本和一个较新版本之间的差异。
His website isn't very clear but as I recall the price for the Pro version was $10.
他的网站不是很清楚,但我记得专业版的价格是10美元。
#2
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.
正如您所说,您已经完成了基于Web的通用查询工具。 JET的问题在于您无法像使用一台SQL服务器那样将其作为数据库服务器连接,以便处理对表和其他维护过程的更改。 Jet不是客户端/服务器RDBMS。您需要在服务器中安装一个应用程序,就像您已经使用基于Web的通用工具一样,或者将数据库下载到您的计算机上。这就是为什么你做了一些程序并将它们作为asp页面在服务器中定位的原因。
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
无论如何你可以使用JetSQLConsole,如果你不想使用Planedisaster或Access,但请记住,你总是需要服务器上的一个应用程序来为你工作
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.
您还可以使用“在您的计算机上”访问并连接到位于URL(http://myserver/mydatabase.mdb)中的数据库,但请记住,当您执行此操作时,您正在下载所有数据库,当您保存它时,您再次上传。