<％=射线％GT;在线查询analzyer访问2000 [英] <%=ray%> online query analzyer for access 2000

问题描述

嗨雷......前一段时间你解释了一个优雅的解决方案，让我能够在我的在线访问2000

数据库中创建和编辑现有的表格和查询。 ...你可以提供关于这个或可能是一些

入门代码的更新链接吗？


我只是厌倦了在发生时发生的同步问题

你离线调整基础表和查询然后必须覆盖

实时数据库吗？


非常感谢Jason

Hi Ray...a while ago you explained an elegant solution to enable me to
CREATE and EDIT existing tables and queries inside my online access 2000
database.... could you provide refresher links on this or possibly some
starter code?

I am just so sick of the syncronization problems that come into play when
you adjust underlying tables and queries offline and then have to overwrite
the live database?

Many thanks Jason

推荐答案

这可能是我发布的链接。 （请注意，此页面将会在您的显示器上显示一个不专业的字眼，所以如果您在教堂工作

或其他什么，请确保您不会冒犯任何人。）

http： //rtfm.atrax.co.uk/infinitemonk...es/asp/908.asp


这是我几个月后发布到另一个论坛的内容返回。


< quote>


你可以用sql命令修改你的Acccess db如果你不能把你的

网站离线。你可以自己设置一个受密码保护的SQL

命令页面，如下所示：

< form name =" frmDatabase"方法= QUOT;交" action =" sql.asp">

在下面输入SQL命令< BR>

< textarea name =" txtSQL" style =" width：550px;高度：100px;">< / textarea>

<输入名称=" cmdSubmit"类型= [提交" value =" Submit">

< / form>


然后将其发布到以下页面：


sSQL = Request.Form（" txtSQL"）

''''创建你的连接并在这里连接

YourConnectionjADO.Execute sSQL


您可以传递类似ALTER TABLE [TableName] ADD COLUMN

NameOfYourNewColumn text（100）"


请确保大量保护页面！如果未经授权的人

进入，他可以删除你的所有数据，丢弃你的桌子等。

< / quote>


雷在工作


" jason" < JA *** @ catamaranco.com>在消息中写道

news：ek ************* @ tk2msftngp13.phx.gbl ...

This is probably the link that I posted. (Be aware that this page will
display an unprofessional word on your monitor, so if you work at a church
or something, make sure you don''t offend anyone.)

http://rtfm.atrax.co.uk/infinitemonk...es/asp/908.asp

And here is something that I posted to another forum a few months back.

<quote>

You can modify you Acccess db with sql commands if you can''t take your
site off line. You can just make yourself a password protected SQL
command page like so:
<form name="frmDatabase" method="post" action="sql.asp">
Enter SQL Command Below<BR>
<textarea name="txtSQL" style="width: 550px; height: 100px;"></textarea>
<input name="cmdSubmit" type="submit" value="Submit">
</form>


Then post that to a page like:

sSQL = Request.Form("txtSQL")
''''create your connection and connect here
YourConnectionjADO.Execute sSQL

You can pass things like "ALTER TABLE [TableName] ADD COLUMN
NameOfYourNewColumn text(100)"

Just make sure you protect you pages heavily! If unauthorized person
gets in there, he could delete all your data, drop your tables, etc.
</quote>

Ray at work

"jason" <ja***@catamaranco.com> wrote in message
news:ek*************@tk2msftngp13.phx.gbl...

嗨雷......前段时间你解释了一个优雅的解决方案，使我能够在我的在线访问2000
数据库中创建和编辑现有的表格和查询....你可以提供关于这个或可能一些的更新链接
启动代码？

当你在离线调整底层表和查询然后必须
覆盖实时数据库时，我对同步问题感到厌烦？<非常感谢Jason

Hi Ray...a while ago you explained an elegant solution to enable me to
CREATE and EDIT existing tables and queries inside my online access 2000
database.... could you provide refresher links on this or possibly some
starter code?

I am just so sick of the syncronization problems that come into play when
you adjust underlying tables and queries offline and then have to overwrite the live database?

Many thanks Jason

谢谢Ray ...虽然他的例子中唯一的曲线球是他们

是在JScript中，他似乎使用了一个Windows脚本组件，它不会对我在我的网络主机上使用时可以使用......

我不认为你遇到任何纯粹的asp例子......？


再次感谢

Jason

雷在<％= sLocation％GT;" < myfirstname at lane34 dot com>在消息中写道

新闻：#S ************** @ tk2msftngp13.phx.gbl ...

Thanks Ray...although the only curve balls with his examples are that they
are in JScript and he seems to use a Windows Script Component which will not
be avialable to me to use on my web host......
I don''t suppose you have come across any pure asp examples...?

Thanks again
Jason
"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:#S**************@tk2msftngp13.phx.gbl...

这可能是我发布的链接。 （请注意，此页面会在您的显示器上显示不专业的字样，所以如果您在教堂工作
或其他什么，请确保您不会冒犯任何人。）

http://rtfm.atrax.co。英国/ infinitemonk ... es / asp / 908.asp

这是我几个月前发布到另一个论坛的内容。

<引用>

如果你不能让你的
网站脱机，你可以用sql命令修改你的Acccess数据库。你可以自己设置一个受密码保护的SQL
命令页面：

< form name =" frmDatabase"方法= QUOT;交" action =" sql.asp">
在下面输入SQL命令< BR>
< textarea name =" txtSQL" style =" width：550px; height：100px;">< / textarea>
< input name =" cmdSubmit"类型= [提交" value =" Submit">
< / form>

然后将其发布到以下页面：

sSQL = Request.Form （txtSQL）
''''创建连接并在此处连接
YourConnectionjADO.Execute sSQL

您可以传递ALTER TABLE [TableName] ADD COLUMN之类的内容
NameOfYourNewColumn text（100）"

请确保您大力保护页面！如果未经授权的人员进入那里，他可以删除你的所有数据，丢弃你的桌子等等。

< / quote>

雷在工作


" jason" < JA *** @ catamaranco.com>在消息中写道
新闻：ek ************* @tk2msftngp13.phx.gbl ...

This is probably the link that I posted. (Be aware that this page will
display an unprofessional word on your monitor, so if you work at a church
or something, make sure you don''t offend anyone.)

http://rtfm.atrax.co.uk/infinitemonk...es/asp/908.asp

And here is something that I posted to another forum a few months back.

<quote>

You can modify you Acccess db with sql commands if you can''t take your
site off line. You can just make yourself a password protected SQL
command page like so:
<form name="frmDatabase" method="post" action="sql.asp">
Enter SQL Command Below<BR>
<textarea name="txtSQL" style="width: 550px; height: 100px;"></textarea>
<input name="cmdSubmit" type="submit" value="Submit">
</form>


Then post that to a page like:

sSQL = Request.Form("txtSQL")
''''create your connection and connect here
YourConnectionjADO.Execute sSQL

You can pass things like "ALTER TABLE [TableName] ADD COLUMN
NameOfYourNewColumn text(100)"

Just make sure you protect you pages heavily! If unauthorized person
gets in there, he could delete all your data, drop your tables, etc.
</quote>

Ray at work

"jason" <ja***@catamaranco.com> wrote in message
news:ek*************@tk2msftngp13.phx.gbl...

嗨雷...前一段时间你解释一个优雅的解决方案，使我能够在我的在线访问2000
数据库中创建和编辑现有的表和查询....你能提供关于这个或可能是一些启动代码的更新链接吗？

当你在离线调整底层表和查询然后必须

Hi Ray...a while ago you explained an elegant solution to enable me to
CREATE and EDIT existing tables and queries inside my online access 2000
database.... could you provide refresher links on this or possibly some
starter code?

I am just so sick of the syncronization problems that come into play when you adjust underlying tables and queries offline and then have to

覆盖

post_quotes>实时数据库？

非常感谢Jason

the live database?

Many thanks Jason

I我也正在查看此代码段 -

http：// www.codetoad.com/asp_query_displayer.asp

" Ray at<％= sLocation％>" < myfirstname at lane34 dot com>在消息中写道

新闻：#S ************** @ tk2msftngp13.phx.gbl ...

I am also looking at this code snippet -

http://www.codetoad.com/asp_query_displayer.asp
"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:#S**************@tk2msftngp13.phx.gbl...

这可能是我发布的链接。 （请注意，此页面会在您的显示器上显示不专业的字样，所以如果您在教堂工作
或其他什么，请确保您不会冒犯任何人。）

http://rtfm.atrax.co。英国/ infinitemonk ... es / asp / 908.asp

这是我几个月前发布到另一个论坛的内容。

<引用>

如果你不能让你的
网站脱机，你可以用sql命令修改你的Acccess数据库。你可以自己设置一个受密码保护的SQL
命令页面：

< form name =" frmDatabase"方法= QUOT;交" action =" sql.asp">
在下面输入SQL命令< BR>
< textarea name =" txtSQL" style =" width：550px; height：100px;">< / textarea>
< input name =" cmdSubmit"类型= [提交" value =" Submit">
< / form>

然后将其发布到以下页面：

sSQL = Request.Form （txtSQL）
''''创建连接并在此处连接
YourConnectionjADO.Execute sSQL

您可以传递ALTER TABLE [TableName] ADD COLUMN之类的内容
NameOfYourNewColumn text（100）"

请确保您大力保护页面！如果未经授权的人员进入那里，他可以删除你的所有数据，丢弃你的桌子等等。

< / quote>

雷在工作


" jason" < JA *** @ catamaranco.com>在消息中写道
新闻：ek ************* @tk2msftngp13.phx.gbl ...

This is probably the link that I posted. (Be aware that this page will
display an unprofessional word on your monitor, so if you work at a church
or something, make sure you don''t offend anyone.)

http://rtfm.atrax.co.uk/infinitemonk...es/asp/908.asp

And here is something that I posted to another forum a few months back.

<quote>

You can modify you Acccess db with sql commands if you can''t take your
site off line. You can just make yourself a password protected SQL
command page like so:
<form name="frmDatabase" method="post" action="sql.asp">
Enter SQL Command Below<BR>
<textarea name="txtSQL" style="width: 550px; height: 100px;"></textarea>
<input name="cmdSubmit" type="submit" value="Submit">
</form>


Then post that to a page like:

sSQL = Request.Form("txtSQL")
''''create your connection and connect here
YourConnectionjADO.Execute sSQL

You can pass things like "ALTER TABLE [TableName] ADD COLUMN
NameOfYourNewColumn text(100)"

Just make sure you protect you pages heavily! If unauthorized person
gets in there, he could delete all your data, drop your tables, etc.
</quote>

Ray at work

"jason" <ja***@catamaranco.com> wrote in message
news:ek*************@tk2msftngp13.phx.gbl...

嗨雷...前一段时间你解释一个优雅的解决方案，使我能够在我的在线访问2000
数据库中创建和编辑现有的表和查询....你能提供关于这个或可能是一些启动代码的更新链接吗？

当你在离线调整底层表和查询然后必须

Hi Ray...a while ago you explained an elegant solution to enable me to
CREATE and EDIT existing tables and queries inside my online access 2000
database.... could you provide refresher links on this or possibly some
starter code?

I am just so sick of the syncronization problems that come into play when you adjust underlying tables and queries offline and then have to

覆盖

post_quotes>实时数据库？

非常感谢Jason

the live database?

Many thanks Jason

这篇关于&LT;％=射线％GT;在线查询analzyer访问2000的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！