Ramachandran
New Member
- Joined
- Oct 17, 2011
- Messages
- 47
In my current system I have one Excel file where the user interacts through forms and data are written to a hidden sheet mimicking a database.
Conversely whenever a sheet is opened it is populated with data from the hidden sheets. All cells are locked for editing, every user input is through a form with the proper constraints, the input is processed through VBA and then written/read.
The "database" contains one sheet with all employees and employee data with an unique identifier,
and a few other sheets linking the employeeID with work schedules, etc.
The Macro-enabled Excel file is located on a server, and a few people use it every day - one at a time.
Naturally it would be better if several people could open the file at the same time - while keeping data integrity.
Any tips on how to go about?
SQLite, MySQL, Access, write-to-and-read-from-csv,...?
Further reading?
Conversely whenever a sheet is opened it is populated with data from the hidden sheets. All cells are locked for editing, every user input is through a form with the proper constraints, the input is processed through VBA and then written/read.
The "database" contains one sheet with all employees and employee data with an unique identifier,
and a few other sheets linking the employeeID with work schedules, etc.
The Macro-enabled Excel file is located on a server, and a few people use it every day - one at a time.
Naturally it would be better if several people could open the file at the same time - while keeping data integrity.
Any tips on how to go about?
SQLite, MySQL, Access, write-to-and-read-from-csv,...?
Further reading?