且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

允许没有Access 97能力的用户查看表中的数据和搜索数据。

更新时间:2023-02-25 19:23:01

一个*********** @ bcbsmn.com 写道:
我有点腌渍。
一切都是顺利进行,我向他们提供了他们最初想要的VBA应用程序。

然而,昨天他们向我扔了一枚炸弹。他们现在希望所有索赔审查员和服务专家都能访问数据,这个任务必须在2005年12月16日之前完成。这些用户必须能够访问我的3个表,并且能够使用两个不同的标准有效地搜索数据库(主表中的35,000条记录)。这些
新用户将累计超过2,000人(虽然,并发性低。一次不超过30个用户),只有三分之一的用户拥有Access 97他们的机器。我不能要求所有用户在他们的机器上安装A97,因为公司必须按照许可证的价格支付该软件的费用。此外,他们将在2006年第二季度用office 2003替换他们旧的办公室套餐。我没有A97的开发者版本,所以我不能只为每个人创建一个运行时使用。这让我相信我需要根据数据库制作某种类型的网页。 (我不知道怎么做。
ASP.Net?)

除了香草A97之外,我几乎没有任何其他开发工具供我使用,也没有经验处理随着任何一种网络的发展。我所拥有的所有有限经验都是使用Visual Basic。
我对网页开发知之甚少,不知道我不知道什么,我必须开发,测试,并在两个月内实现一个动态的网页页面。我可以要求预算购买一些
开发工具,但我必须确切知道我需要什么。 (并且它们不会花费太多.Visual Studio可能太贵了。)

所以,我的问题是:什么是最简单,最便宜,最少参与的?br />方法将Access数据库数据打开给在他们的计算机上没有MS Access的大量受众?除非容易和便宜,有没有办法在没有任何额外工具的情况下做我需要做的事情?

我想要做的是将当前数据库复制到
new .mde文件(新用户不需要立即更新数据),然后以某种方式将网页基于此表。但是,我不知道如何使用来自网页的参数输入来运行查询,并且显示这些结果。事情进一步复杂化的事实是我有三张桌子;问题的一个主要表格,以及两个包含特定问题的评论和位置时间戳的辅助表格,我需要通过主表格中的链接查看辅助表格。

我意识到我的问题的详细答案可以轻松填写​​一本书。
我正在寻找的是一种使用方法的一般概念以及
什么工具我需要完成它。

提前感谢你们的任何建议!
I''m in a bit of a pickle.

My employer, a health insurance firm, had me design a small database to
track benefit issues. The intended users were technical specialists and
some managers (about 90 people, no more than 10 concurrent users at any
one time) all of which had Access 97 loaded on their machines.
Everything was going smoothly, and I delivered them their VBA
application that does everything they initially wanted it to.

However, yesterday they dropped a bomb on me. They now want all claims
examiners and service specialists to have access to the data, and this
task MUST be completed by 12/16/2005. These users must have access to 3
of my tables, and be able to effectively search the database (about
35,000 records in the primary table) with two different criteria. These
new users will add up to well over 2,000 people (albeit, low
concurrency. No more than 30 users at any one time), and only one third
of them have Access 97 on their machines. I cannot require all users to
have A97 on their machines as the company must pay for that software on
a per license basis. Furthermore, they will be replacing their old
office package with office 2003 in 2nd qtr of 2006. I do not have the
Developers version of A97, so I cannot just make a runtime for
everybody to use. This leads me to believe I need to make some sort of
web page based off the database. (I have no idea how to do that.
ASP.Net?)

I have virtually no other development tools at my disposal other than
vanilla A97, and no experience dealing with ANY kind of web
development. All of the limited experience I have is with Visual Basic.
I don''t even know enough about web page development to know what I
don''t know, and I have to develop, test, and implement a dynamic web
page in two months. I can possibly request budget to buy some
development tools for the job, but I have to know exactly what I''m
going to need. (And they can''t cost too much. Visual Studio is
probably too much money.)

So, my question is this: What is the easiest, cheapest, least involved
method to open up your Access database data to a large audience who do
not have MS Access on their machines? Barring easy and cheap, IS there
a way to even do what I need to do without any additional tools?

What I was thinking of doing is duplicating the current database to a
new .mde file (the new users do not need instantly updated data), then
basing a web page in some way off of this table. However, I have no
idea how to run a query with parameter inputs from a web page, and have
those results display. Further complicating things is the fact that I
have three tables; one primary table for the issues, and two secondary
tables which hold the comments and location time stamps for that
particular issue, and I need the secondary tables viewable via links
from the main table.

I realize a detailed answer to my question could easily fill a book.
What I''m looking for is a general idea of a method to use as well as
what tools I''ll need to complete it.

Thanks in advance for any advice you guys may have!



我认为你的公司需要雇用一个人网络专业知识。


bob


I think your company needs to hire someone with web expertise.

bob


他们拥有具备网络专业知识的人员,可以轻松完成这项工作。然而,

他们没有时间及时将注意力转移到这个特定的问题上,以及在截止日期前处理它的问题。换句话说,我就是。

They have people with web expertise who could do this easily. However,
they will not have time to turn their attention to this particular
problem in time to deal with it by the deadline. In other words, I''m it.


*********** @ bcbsmn.com 写道:
他们拥有具有网络专业知识的人,他们可以轻松地做到这一点。但是,他们没有时间及时将注意力转移到这个特定的问题上,并在截止日期前及时处理。换句话说,我是
它。
They have people with web expertise who could do this easily. However,
they will not have time to turn their attention to this particular
problem in time to deal with it by the deadline. In other words, I''m
it.




经验丰富的网络人可能会在几个小时内敲出符合最低

要求的东西。管理层需要其中一个人

分配时间或放弃要求。


-

我不喜欢检查此邮件附带的电子邮件帐户

。发送给...

在Hunter dot com的RBrandt



An experienced "web guy" could bang out something that meets the minimum
requirements in a few hours. Management needs to have one of those guys
allocate the time or drop the requirement.

--
I don''t check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com