远程管理Access2K [英] Remotely managing Access2K
问题描述
由于许可原因，我计划在特定网站上使用ASP.NET 3.5 / Access 2K
..
我可以使用哪些工具远程管理Access 2K DB？
简单的ODBC连接是否足够？我读了一些帖子警告反对
ADP，（另外我不想重写额外的代码。）。如果ODBC没问题，我可以假设远程数据库可以通过本地客户端
应用程序进行管理。是否有任何网络问题需要注意哪些？b $ b可能会造成严重破坏？感谢您的任何指示。
" helveticus" < ms ****** @ gmail.com在留言中写道
news：22 ************************ ********** @ m36g2000 hse.googlegroups.com ...
由于许可原因，我打算使用ASP.NET 3.5 /访问2K
特定网站..
我可以使用哪些工具远程管理Access 2K DB？
简单的ODBC连接是否足够？我读了一些帖子警告反对
ADP，（另外我不想重写额外的代码。）。如果ODBC没问题，我可以假设远程数据库可以通过本地客户端
应用程序进行管理。是否有任何网络问题需要注意哪些？b $ b可能会造成严重破坏？谢谢你的任何指示。
首先要做的事情是：两年前，对Access 2000的主流支持几乎已经退休了。虽然该产品目前正在得到扩展支持，但是这也将在明年年底结束，之后如果发生任何事情，你将独自支付。另外，扩展的支持合同非常昂贵 - 你确实有一个，不是吗...？
其次，ODBC非常如今的旧技术，多年前已经被
OleDb所取代。 远程管理是什么意思？它只是
数据，还是你要修改数据库架构，进行备份等......？
第三，Jet引擎不太合适对于Web应用程序，
尤其是那些具有大量并发连接的应用程序：
http://en.wikipedia.org/wiki/Microso...atabase_Engine
有什么理由不能使用SQL Server Express Edition？
http://msdn.microsoft .com / zh-CN / express / aa718378.aspx
-
Mark Rae
ASP.NET MVP
http://www.markrae.net
感谢您的回复。我一直在使用A2K和SQL Express，
使用A2K作为前端。但是，我发现没有什么比在短时间内设计前端应用程序更好的了。
在目前的情况下，我想利用数据库经理我
写在A2K。它允许我对所有相关的
SQL Express表（没有数据库模式修改）以及特定的
处理进行基本的CRUD操作。我不想在网络的Admin
部分复制这项工作。理想情况下，信息应该在本地下载/上传和处理
。假设我升级到ACC2003 / ACC2007，那将是这种b
远程数据库管理例如，可以通过OleDB吗？ TIA。
" helveticus" < ms ****** @ gmail.com写信息
新闻：51 ************************ ********** @ 34g2000h sf.googlegroups.com ...
感谢您的回复。我一直在使用A2K和SQL Express，
使用A2K作为前端。但是，我发现在短时间内没有什么比设计前端应用程序更好的了。
呃，好的......我很疑惑你为什么要使用Access作为前端
来SQL Server Express有自己的版本：
http://www.microsoft.com/downloads/d...displaylang=en
在目前的情况下，我想利用我在A2K写的数据库管理员$ b / b。它允许我对所有相关的
SQL Express表（没有数据库模式修改）以及特定的
处理进行基本的CRUD操作。
呃，你现在说你正在使用的RDBMS是SQL Server
Express ......？如果是这样，我无法理解你需要什么访问...
-
Mark Rae
ASP.NET MVP
http://www.markrae.net
Because of licensing reasons, I plan on using ASP.NET 3.5 /Access 2K
for a specific site..
What tools could I use to remotely manage the Access 2K DB? Would a
simple ODBC connection be adequate? I read some posts warning against
ADP, (plus I don''t want to re-write extra code.). If ODBC is ok, I
presume the remote DB could be managed via a local client
application. Are there any networking issues to be aware of which
possibly could play havoc? Thanks for any pointers.
"helveticus" <ms******@gmail.comwrote in message
news:22**********************************@m36g2000 hse.googlegroups.com...
Because of licensing reasons, I plan on using ASP.NET 3.5 /Access 2K
for a specific site..
What tools could I use to remotely manage the Access 2K DB? Would a
simple ODBC connection be adequate? I read some posts warning against
ADP, (plus I don''t want to re-write extra code.). If ODBC is ok, I
presume the remote DB could be managed via a local client
application. Are there any networking issues to be aware of which
possibly could play havoc? Thanks for any pointers.First things first: mainstream support for Access 2000 was retired almost
two years ago. Although the product is currently under extended support,
this is also set to end next year, after which you will be on your own if
anything happens. In addition, an extended support contract is extremely
expensive - you do have one, don''t you...?
Secondly, ODBC is very old technology these days, having been superseded by
OleDb many years ago. What do you mean by "remotely manage"? Is it just
data, or will you be modifying the database schema, taking backups etc...?
Thirdly, the Jet engine is not really suitable for web applications,
especially those with lots of concurrent connections:
http://en.wikipedia.org/wiki/Microso...atabase_Engine
Is there any reason that you can''t use SQL Server Express Edition?
http://msdn.microsoft.com/en-us/express/aa718378.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
Thanks for the reply. I have been working with A2K and SQL Express,
using A2K as the front-end. However, I find nothing beats Access for
designing front-end applications in short notice.
In the present case, I would like to capitalize on the DB manager I
wrote in A2K. It allows me to do basic CRUD operations on all relevant
SQL Express tables (no database schema modifications) plus specific
processing. I don''t want to replicate this work in the web''s Admin
section. Ideally, the info should be download/uploaded and processed
locally. Assuming I upgrade to ACC2003/ACC2007, would this kind of
"remote DB management" be possible via OleDB for instance? TIA.
"helveticus" <ms******@gmail.comwrote in message
news:51**********************************@34g2000h sf.googlegroups.com...
Thanks for the reply. I have been working with A2K and SQL Express,
using A2K as the front-end. However, I find nothing beats Access for
designing front-end applications in short notice.Er, OK... I''m puzzled as to why you would want to use Access as a front-end
to SQL Server Express when it has its own:
http://www.microsoft.com/downloads/d...displaylang=en
In the present case, I would like to capitalize on the DB manager I
wrote in A2K. It allows me to do basic CRUD operations on all relevant
SQL Express tables (no database schema modifications) plus specific
processing.Er, so are you now saying that the RDBMS you''re using is SQL Server
Express...? If so, I can''t understand what you need Access for...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
这篇关于远程管理Access2K的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
