的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易于使用，对于这几年的工作簿使用由几个人来规划/添加关于当前生产状态更改/笔记。整个工作簿中有几个要素的（有关产品的其他信息都存储在不同的表，等），但缺乏更多。

我勾勒出它的样子（我从内存中重新创建它，简单的布局，因此它可以读取）：

这只是一个草图，但原来是丑陋的，不切实际的和有限的这一个。

我希望能创建简单的基于表单的应用程序，它可以使用至少有几个人同时（每个人有他自己的副本，但所有副本将使用用于存储信息的单一MS Access数据库）。

什么是我需要知道，如果我打算做到这一点？什么是创建多用户应用程序的指导方针？

我也想知道有没有什么办法可以重新使用免费的一个类似的布局/包含.NET控件？标签和都都没有问题，但人们需要转移这些丰富多彩的酒吧轻松地以及在尽可能轻松添加新的。我知道，在其他语言中存在的帆布一样的控制，我想使用一个在这里。这是一个不错的选择，或者是有其他更好的呢？

解决方案

1. 我不会用C ++来做到这一点，就没有真正的需要。我建议VB.NET或C＃...当然，除非你已经非常熟悉C ++而不是其他语言。

2. 没有的免费的控制自带的.NET框架做你所描述的。由其他人在这里提出的第三方控件是巨大的。也有另一种在 http://www.janusys.com

3. 多用户网络数据库系统不应该使用Microsoft Access，因为它并不完全功能以及在该特定环境中实施。你可以使用类似WCF接口来访问MDB文件，并拥有所有的应用程序的WCF组件说话，但是这是完全没有必要的海事组织。我会建议使用Microsoft SQL Server 2008前preSS。非常强大并免费为一定数量的用户。如果你想要去开源，我会建议使用的Postgres，而不是MySQL的。这只是我的建议，因为我相信这是一个更好的系统是最新的与关系数据库的标准。

4. 试着使用一些第三方工具，如亚音速与数据库进行交互。非常有益的，使用相当简单。 www.subsonicproject.com。

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.

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?

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?

解决方案

1. 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.

2. 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

3. 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.

4. 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屋！