Hey folks, I need some advice on a project I’m working on. We’re trying to replace our old Excel workbook for production planning with a new app. The current setup is pretty basic and lacks features we need.
I’m thinking of using Visual C++ to build a forms-based app that connects to an MS Access database. The tricky part is we need multiple users to work on it at the same time, each with their own copy but sharing the same database.
Two main questions:
What should I keep in mind for making this a multi-user app? Any tips or best practices?
For the GUI, I want to recreate something like our current layout where users can easily move and add colored bars (kind of like a Gantt chart). Are there any free .NET controls that could help with this? I’ve heard of canvas-like controls in other languages, but I’m not sure if that’s the best way to go here.
Having worked on similar projects, I can offer some insights. For multi-user functionality, consider implementing a robust locking mechanism in your Access database to prevent conflicts. You might want to look into ADO.NET for efficient data access and management.
As for the GUI, while there aren’t many free .NET controls for Gantt-like charts, you could create a custom control using GDI+ in Windows Forms. This approach gives you flexibility to design the exact layout you need. I’ve successfully used this method to create draggable, colorable bars representing production schedules.
One caveat: Access might struggle with multiple concurrent users. If you find performance issues, consider migrating to SQL Server Express. It’s free and handles concurrency much better. Also, don’t forget to implement proper error handling and logging – it’s crucial for multi-user apps.
hey zoestring42, have you thought about using a local web app instead? it might be easier for multi-user stuff. for the gantt chart, you could try using javascript libraries like dhtmlxGantt - its pretty good for what youre describing. just a thought!
hey, have you considered a web app for easier multi-user support? maybe try html5 canvas for your gantt chart? what size of operation r u planning for? would love to know more!