Access 2010 数据库 - 不需要 Web 服务器的前端？
背景
我需要能够显示可以捕获用户点击内容的图表。因此，对于饼图，如果用户单击饼图块，我应该能够捕获他选择的块。散点图应该捕获什么图等。Access-UI 无法捕获这些内容，只能捕获用户单击图形的情况。所以我需要一个不同的解决方案。
问题
我们无法访问网络服务器。前端需要直接与access数据库连接。那么我可以使用哪些前端解决方案来为我提供解决问题所需的 UI 灵活性呢？
可能的解决方案？
- 在access中使用silverlight（http://desktopweb.blogspot.com/2010/12/using-silverlight-with-access-part-ii.html）
- 通过ADO连接到Access数据库的Winforms
有没有什么可以让我使用HTML /JS 还是 flash？ HTML/JS 将是最好的解决方案，其次是 flash，因为它具有广泛的支持。我正在研究Web浏览器控制，但我不完全清楚它是打开本地HTML文件还是通过http浏览。我也不清楚它是否支持JS或可以加载Flash。
background
I need to be able to display charts that can capture what the user has clicked on. So for a pie chart, if a user clicks on a pie piece, I should be able to capture which piece he selected. Scatter plot should capture what plot, etc. Access-UI can't capture these things, only that a user clicked on the graph. So I need a different solution.
problem
We do not have access to a web server. The front end needs to connect directly with the access database. So what front end solutions can I use that will give me the UI flexibility I need to solve my problem?
possible solutions?
- Use silverlight in access (http://desktopweb.blogspot.com/2010/12/using-silverlight-with-access-part-ii.html)
- Winforms that connects to Access database via ADO
Is there anything that allows me to use HTML/JS or flash? HTML/JS would be the best solution, followed by flash just due to its wide support. I was researching Web Browser Control but I am not completely clear on whether it is opening local HTML files or browsing through http. I also wasn't clear if it supports JS or can load Flash.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
当您第一次谈到点击功能时，我的第一个想法是可以使用 SSRS 进行报告。最简单的方法是拥有一个报告服务器并通过浏览器提供报告。然而你说你不能有一个网络服务器，所以我猜报告服务器也已经出来了。
不过，您仍然可以使用 BIDS 或报表生成器来制作报表，然后使用 .net 风格的报表查看器控件来显示报表。请注意，您必须将它们转换为 RDLC 文件并将数据提供给它们。
这是我的 2p 价值，我不会评论 flash 或 silverlight，因为我对它们了解不够，无法做出明智的推荐
When you first said about the click though capability my first thought was the reporting that is possible using SSRS. The easiest way is to have a reporting server and have the reports available through a browser. However you say you can’t have a web server so I’m guessing that a reporting server is also out.
You could however still use BIDS or report builder to make your reports and then the report viewer control in a flavour of .net to display the reports. Note that you have to convert them to RDLC files and feed the data to them.
That’s my 2p worth, I won’t comment on flash or silverlight as I don’t know enough about them to make an informed recommendation
Access 中可用的 Web 浏览器控件可以使用可通过 URL 访问的任何资源，或者您可以为其分配一个 HTML 字符串（当然是有效的）。我忘记了您用于后者的确切属性，但它是可行的（上次我实现 Web 浏览器控件以显示 Access 应用程序中的 HTML 时我不知道这一点，因此创建了一个临时文件，并且从未返回替换一旦我学会了如何直接分配 HTML 就可以了——所以我当然忘记了如何！）。
The web browser control that's usable in Access can use any resource that can be reached via a URL, or you can assign a string of HTML (valid, of course) to it. I forget the exact property you use for the latter, but it's doable (I didn't know this the last time I implemented a web browser control to display HTML from an Access app, so created a temp file, and never went back to replace that with just assigning the HTML directly once I learned how -- so I forgot how, of course!).