Visual C++ application as a frontend to MS Access database - multiuser data access and canvas-like GUI questions.

Answer 1

If you are already going to re-write/reimplement what you have, I'd stay away from access.

You're probably best off (in time and money) to buy a control from one of the big name vendors.

Answer 2

The DevExpress Winforms Scheduler isn't free - but looks like it would do pretty much everything you need. Using a component such as this (there are others) would most likely be less expensive for your organisation than creating one from scratch: plus I've found the DevExpress fellows to give top-notch support and help.

Although their samples are oriented mostly towards C# and VB.NET, this would work just fine from Managed C++.

As others have stated, avoid Access for data storage. If this is a single-user system you may want to consider simple XML, or if a relational database is required database engines such as MySQL or SQL Server would definitely be a better bet.

Answer 3

As someone who has some fairly large amount of code stuck in Access my recommendation is if at all possible run to either ms sql or preferably mysql. Don't worry too much moving the db to one of these is not real hard. Then you have a wide variety of tools to choose from. After you move the data then determine what the right tool is. The open source world has a lot of good report writing graphical tools I happen to like Birt which can run against most db's.. Access is a real dead end, good for quick hacks but horrible to live with...

Answer 4

My memory tells me Access had an 'Upsizing wizard' option to port the db into SQL. This would allow you to use SQL server instead of a single Ms Access file.

see http://support.microsoft.com/default.aspx?scid=kb;en-us;Q237980

The problem with using an Acess db is that the file is locked when you open it. This means multiusers would have a big problem if more than one person wants to write/read it. XML is also not an good option because its just a single file and would also have problems with multiple users. XML is also SLOW and takes up a lot of memory. If your data will grow this wouldn't be a good option. An actual SQL database does not suffer this problem and will allows multiple users.

As for controls for your UI. I am not aware of any standard controls that would do what you want. You probably would do best to make your own custom control.

Looking at your sketch, it looks alot like a GANTT chart (ie Ms Project)

Answer 5

I agree - use just about anything other than MS access. Might sound cheap and easy but there are many other cheap and easy ways of doing things (that won't cause you to lose sleep at night).

If you're looking for ways of representing this, you could have a look at this SilverLight Gantt chart.

Answer 6

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.