Hello,
I have an excel application with front end and back end (both are excel files).
I managed to solve multiple user by implementing write lock (when user write to the DB, others can not write).
Anyway, after 1 day of intensive work the back end data file got corrupted.
What is a good and reliable alternative to excel for storing data tables ?
Will my application work better if I will replace excel with access (as back end DB) ?
Is there any other alternative ?
Thank you for your help
Bookmarks