I have written a simple database program in Delphi 2009 which currently uses static arrays (of records) to store the database information. It is a relatively primitive solution at the moment which works, but the database is kept only locally and only one user can use it at a time.
I now want to re-design the database structure and need some help.
I want a Delphi 2009 compatible source code:
1. Do not use arrays and records anymore. Use tables instead.
2. Program the database as a client – server structure, with the ability for users to log into the database over the internet or LAN (the server will run on a local PC with Windows XP Pro or Vista)
3. Multi user capabilities – several users should be able to use the database at the same time and any modified data should be updated on the server immediately.
There is no need to import existing data into the new database.
I have no preference re the underlying database format. Sqlite, BDE or MS Access 2007 could be an option.
I am also using the DevExpress ExpressQuantumTreeList Suite. It would be excellent if you could bin the data to their database-aware hybrid tree / grid list component. If you can do this I would definitely prefer you over other bidders.
I can provide more details of the database fields/tables later on.