Visual C ++应用程序作为MS Access数据库的前端 - 多用户数据访问和画布式GUI问题 [英] Visual C++ application as a frontend to MS Access database - multiuser data access and canvas-like GUI questions
问题描述
在我工作的公司，我有机会写一个应用程序，它将取代旧的Excel工作簿，用于计划生产队列。因为VBA很简单，Excel很容易使用，几年来，这个工作簿被几个人用来计划/添加关于当前生产状态的更改/注释。整个工作簿几乎没有功能（有关产品的附加信息存储在不同的工作表等），但缺少更多。
In company that I work for, I was given the opportunity to write an application, which would replace the old Excel workbook, which is used to plan the production queue. Because VBA was simple and Excel was easy to use, for few years this workbook was used by several people to plan/add changes/notes about current production status. Whole workbook has few feature's (additional information about products are stored in different sheets, etc), but is lacking many more.
我草拟了它的样子从内存，简化布局，所以它可以读取）：
I sketched how it looks like (I recreated it from memory, simplified the layout, so it can be readable):
这只是一个草图，但原来的一个是丑陋，不切实际和有限的这一个。
This is only a sketch, but the original one is as ugly, impractical and limited as this one.
我希望创建基于简单表单的应用程序，它可以由至少几个人同时使用（每个人都有自己的副本，但所有副本都使用单个MS Access数据库用于存储信息）。
I was hoping to create simple forms based application, which could be used by at least a few people simultaneously (each one having his own copy, though all copies would use single MS Access database for storing information).
如果我计划完成这项工作，我需要知道什么？创建多用户应用程序的准则是什么？
What do I need to know about if I plan to accomplish this? What are the guidelines for creating multiuser applications?
我还想知道是否有任何方法使用一个免费/包含的.NET控件重新创建类似的布局？标签和类似的都不是问题，但人们需要移动这些多彩的酒吧，以及添加新的，尽可能容易。我知道画布样的控件存在于其他语言，我在想在这里使用。
I would also want to know if is there any way to recreate a similar layout using one of free/included .NET controls? Labels and alike are not the problem, but people need to move those colorful bars easily as well as add new ones in as easy as possible. I know that canvas-like controls exist in other languages and I was thinking about using one here. Is this a good choice or is there another, better one?
推荐答案
-
I wouldn是一个很好的选择，不使用C ++做到这一点，没有真正的需要。我建议VB.NET或C＃...除非你已经非常熟悉C ++，而不是其他语言。
I wouldn't use C++ to do this, there is no real need. I would suggest VB.NET or C#... unless of course you're already highly familiar with C++ and not the other languages.
em>免费控制与.NET框架一起做你所描述的。这里的其他人建议的第三方控制是伟大的。 http://www.janusys.com 还有另一个
There is no free control that comes with the .NET framework to do what you described. The third party controls suggested by others here are great. There is also another at http://www.janusys.com
多用户联网数据库系统不应使用Microsoft Access实现，因为它在该特定环境中不能很好地运行。你可以使用类似WCF的接口到访问MDB文件，并让所有应用程序与WCF组件，但这是完全不必要的IMO。我建议使用Microsoft SQL Server 2008 Express。非常强大，免费为一定数量的用户。如果你想去开源，我建议使用Postgres而不是MySql。这只是我的建议，因为我相信这是一个更好的系统更新与关系数据库标准。
Multi-User networked database systems should not be implemented using Microsoft Access as it doesn't quite function well in that specific environment. You could use something like WCF to interface to an access MDB file and have all apps speak to the WCF component, but that's totally unnecessary IMO. I would recommend using Microsoft SQL Server 2008 Express. Very powerful and free for a certain amount of users. If you want to go open source, I would recommend using Postgres instead of MySql. This is just my recommendation as I believe it's a better system up to date with Relational Database standards.
尝试使用某些其他第三方工具（例如亚音速）与您的数据库进行交互。非常有用和相当简单的使用。 www.subsonicproject.com。
Try to use some other third party tools such as subsonic to interface with your database. Very helpful and fairly simple to use. www.subsonicproject.com.
这篇关于Visual C ++应用程序作为MS Access数据库的前端 - 多用户数据访问和画布式GUI问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
