Hello All,
Please excuse my ignorance of MS Access but I've been trying to organize my backups and I thought ms access would be great to use...big mistake! After 5 hours of trying to figure things out I could have done it manually.
So, I'm committed now and would really appreciate any help to figure out how to do what I'm trying to do!
Ok, here it goes: I'm a stickler for backing up my system, I was in the IT industry for 20+ years and have seen many a person break down in tears because they had lost all their data because of a hardware crash and no backups. I on the other hand, over do it and do not do a good job of organizing my backups. I have 15 drives with multiple copies of my data, majority are photos and video (I'm an amateur sports photographer) so it's time to consolidate my backups.
Sorry, I got off topic...Basically I want to know where my backups are over the 15 drives. I know there's going to be at least 3 copies if not 4 or 5 copies of my data so I want to search (I guess query) the 15 columns of folders and files I have listed in MS Excel and use that info for Access.
So, I have 15 columns with all the files and folders listed under the name of the drives in a worksheet. I would like some how to query all the drives and have a list with the folder/file name and what drives they are on. Example: MyDocs happen to be on Drive A,C,D, and X so the query should output something like MyDocs - Drives, A C D X; Basketball Pics - Drives B C P X and so on.
I'm not sure of the output layout, but something that shows the folder/file names and the corresponding drive it is on.
It sounds like an inventory query but I just could not get anything to work. Even the duplicator function in MS Access could not find duplicates...which I know there is.
Well, I think that's it. Thank you in advance for your help. Cheers