我们正在寻找一种在网络上显示 Access 报告的简单方法。这些报告是内部编写和查看多年的。它们不是简单的表格,而是更复杂的图表和图表。但是,现在组织外部的人需要看到它们。所有数据都可以访问。而且,除了报告之外,其他一切都工作正常。
我们有一个有权查看 Access 数据库的 Web 服务器。但是,Access 数据库服务器不能是 Web 服务器本身。那么,问题是我们如何在网络上查看这些报告?这个优秀的解决方案,我参考它,以防它对其他人有帮助,(https://web.archive.org/web/20211020135306/https://www.4guysfromrolla.com/webtech/042600-1.shtml) 不适用,因为它要求您位于公司内部网。 (尽管,可能可以在内联网之外实现该解决方案,但会出现很多安全漏洞,导致领导该项目的开发人员肯定会被解雇。)如果可能的话,我们也不希望有一个对每个客户都期望的解决方案安装代码,例如访问运行时。
- 有没有一个工具可以读取
当要求时访问报告?或者
- 有没有可以上传的工具
数据来自 Access 数据库
定期并基于最后一次
检索到的数据 - 它可以显示
是用access写的报告吗?
- 其他解决方案...
谢谢!
We're looking for an easy way to display Access reports on the web. These reports have been written and viewed internally for years. They are not simple tables, but more complex charts and graphs. But, now people outside the organization need to see them. All of the data is in access. And, except for reporting everything else is working fine.
We have a web server that has permissions to see the Access database. However, the Access database server cannot be the webserver itself. So, the question is how do we view these reports on the web? This excellent solution, which I reference in case it helps others, (https://web.archive.org/web/20211020135306/https://www.4guysfromrolla.com/webtech/042600-1.shtml) does not apply, as it requires you to be on a company intranet . (Although, it may be possible to implement the solution outside of an intranet, so many security holes would be opened up that the developer leading this project would surely be fired.) If possible, we also do not want a solution that expects every client to install code, for example, the access runtime.
- Is there a tool that can read the
access reports when requested? OR
- Is there a tool that can upload the
data from the Access database on a
periodic basis and based on the last
retrieved data - it can display the
report that was written in access?
- Other solutions ...
Thanks!
发布评论
评论(3)
将报告打印为 pdf,然后将 pdf 文件复制到网络服务器
print the reports to pdf and then copy the pdf files to the webserver
选项:
输出为 PDF。
输出为Access 快照格式并强制用户使用快照查看器。
等待带有 Sharepoint 2010 和 Access Services 的 Access 2010,您就可以回家了(只要您可以将报告重写为完整的 Web 报告,即不使用 VBA,而仅使用 A2010 中的 Web 报告功能)。
Options:
output to PDF.
output to Access snapshot format and force users to use the snapshot viewer.
wait for Access 2010 with Sharepoint 2010 and Access Services and you're home free (as long as you can rewrite your reports to be full web reports, i.e., not VBA and only using the capabilities of web reports in A2010).
我们通过终端服务器将 Access 应用程序(及其报告)作为 Web 应用程序提供。
We deliver an Access app (and reports therefore) over a Terminal Server as a WebApp.