SQUIDD
Well-known Member
- Joined
- Jan 2, 2009
- Messages
- 2,104
- Office Version
- 2019
- 2016
- Platform
- Windows
Hi All
So i have quite a complicated project already built in excel, so i really would like to stick with excel.
I want to have 1 workbook that harbours all of my data, and then simply an my app to modify the data, my app will have all the code etc.
Now i understand the above is easy and i could do this without any issues,
however, i want a multi user app, or several apps that can copy data from and modify the data file.
Before i start this fairly large project, i wnt to make sure im heading off in the right direction.
I guess my real issue is if 2 people try to modify the the data file at the same time.
what are the issues surrounding this, or, should i be considering building something that pre-checks if anyone already has the data file open and put the last change in a que.
the changes will always be extremly small and most of the time it will just be grabbing reports to view.
my plan to view reports from the data was to simply open the data file, copy the data into the app so it can sort and filter each report, so thats a quick open and, grab and close of the data file.
my plan to amend/add new data(only ever one row at a time) was top open the data file, find the correct row of data and simply update with the new info, save and close.
Any help would be great since i want to start off in the right direction.
Im thinking right now i can delfinently put a check if file is already being modified thing in. Then update at the 1st oppertunity.
OR MAYBE
I need to consider time stamping all changes and removing the older data?
Dave
So i have quite a complicated project already built in excel, so i really would like to stick with excel.
I want to have 1 workbook that harbours all of my data, and then simply an my app to modify the data, my app will have all the code etc.
Now i understand the above is easy and i could do this without any issues,
however, i want a multi user app, or several apps that can copy data from and modify the data file.
Before i start this fairly large project, i wnt to make sure im heading off in the right direction.
I guess my real issue is if 2 people try to modify the the data file at the same time.
what are the issues surrounding this, or, should i be considering building something that pre-checks if anyone already has the data file open and put the last change in a que.
the changes will always be extremly small and most of the time it will just be grabbing reports to view.
my plan to view reports from the data was to simply open the data file, copy the data into the app so it can sort and filter each report, so thats a quick open and, grab and close of the data file.
my plan to amend/add new data(only ever one row at a time) was top open the data file, find the correct row of data and simply update with the new info, save and close.
Any help would be great since i want to start off in the right direction.
Im thinking right now i can delfinently put a check if file is already being modified thing in. Then update at the 1st oppertunity.
OR MAYBE
I need to consider time stamping all changes and removing the older data?
Dave