我想简单地附上位于某个Web服务器上的Access 2.0数据库 [英] I would like to attach briefly to an Access 2.0 database located on a web server somewhere

问题描述

我的朋友在网络服务器上有一个数据库应用程序。

他邀请我附上它，这样我就可以定期从

中提取数据。我有几个问题...


1）我有一个到我的ISP的DSL连接，我想我的好友

也有一个。我可以与他的数据建立ODBC连接 -

base吗？我需要收集什么信息？

允许我们这样做？


2）我可以打开连接&断"随意？是否有任何

的缺点与一直留下相关。


3）如果我能做到这一点，其他人（谁不应该）被允许

连接）做到了吗？如果是这样，我们可以阻止它们吗？

I have a friend with a database application on a web server.
He has invited me to attach to it so I can extract data from
it periodically. I have a few questions...

1) I have a DSL connection to my ISP and I think my buddy
has one too. Can I establish an ODBC connection to his data-
base? What information would I need to gather that would
allow us to do this?

2) Can I "turn the connection on & off" at will? Are there any
drawbacks associated with leaving it on all the time.

3) If I can do this, can other people (who shouldn''t be allowed
to connect) do it? If so, can we stop them?

推荐答案

您无法在任何

配置，使用ODBC。


我不熟悉在Internet上使用ODBC驱动程序_并且害怕

你不能做即使你使用Access以外的其他东西作为一个

客户端。


我知道你可以在互联网上使用远程访问软件，所以你可能会

调查pcAnywhere，ReachOut和其他人 - 这将允许您在该服务器上运行

应用程序并从您的计算机上执行输入/查看。


几乎所有人对虚拟专用网的了解都比我更好，但这可能是一种可能性，无论是单独使用还是与
$ b一起使用$ b其他一些软件 - 也许知识渊博的参与者会介入这里

并向我们两个人解释。


Larry Li nson

Microsoft Access MVP

" MLH" < CR ** @ NorthState.net>在消息中写道

news：ph ******************************** @ 4ax.com ...

You cannot attach Access to an Access (Jet) database, of any version, in any
configuration, using ODBC.

I am not familiar with using ODBC drivers _across the Internet_, and fear
you can''t do that, even if you are using something other than Access as a
client.

I know you can use remote access software across the Internet, so you might
investigate pcAnywhere, ReachOut, and others -- that would allow you to run
an application on that server and just do the input/view from your machine.

Almost anyone is much more knowledgeable about Virtual Private Networks than
I am, but that may be a possibility, either alone or in conjunction with
some other software -- perhaps a knowledgeable participant will step in here
and explain it to both of us.

Larry Linson
Microsoft Access MVP
"MLH" <CR**@NorthState.net> wrote in message
news:ph********************************@4ax.com...

我有一个朋友在网络服务器上有一个数据库应用程序。
他邀请我附上它，这样我就可以定期从
中提取数据。我有几个问题...

1）我有一个到我的ISP的DSL连接，我认为我的好友
也有一个。我可以与他的数据库建立ODBC连接吗？我需要收集哪些信息才能让我们这样做？

2）我可以打开和关闭连接吗？断"随意？是否有任何与之相关的缺点。

3）如果我能做到这一点，其他人（不应该被允许连接的人）可以连接吗？ ）做到了吗？如果是这样，我们可以阻止它们吗？

I have a friend with a database application on a web server.
He has invited me to attach to it so I can extract data from
it periodically. I have a few questions...

1) I have a DSL connection to my ISP and I think my buddy
has one too. Can I establish an ODBC connection to his data-
base? What information would I need to gather that would
allow us to do this?

2) Can I "turn the connection on & off" at will? Are there any
drawbacks associated with leaving it on all the time.

3) If I can do this, can other people (who shouldn''t be allowed
to connect) do it? If so, can we stop them?

是的，就像RAdmin那样。它会出现它需要做的
。

Yes, something like RAdmin would do. It
appears it will have to do.

在这里！ ASP将是最好的解决方案。我们可以用它来
来调用一些动作查询来提取你想要的东西。

我可以使用TransferDatabase来导出任何查询

对象''数据，用于将远程对象的数据移动到远程服务器上的另一个
数据库。当我需要导出的数据

时，我可以在这里FTP mdb文件。

Here here! ASP will be the best solution. We can use it
to invoke some action queries to extract what''s wanted.
I could use TransferDatabase to export any of the query
objects'' data to move the remote objects'' data to another
database on the remote server. When just the data I need
has been exported, I can FTP the mdb file here.

这篇关于我想简单地附上位于某个Web服务器上的Access 2.0数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！