I'm hoping someone can offer a bit of advice here. I admit I know nothing about coding but for some reason my boss decided 4 years ago that he wanted me to create an access database using records to keep all our client and worker records on, so that we could easily track who was available, what trades they covered and which clients various workers had been placed with in the past and present. Up to now, what I cobbled together mainly using the wizards and reading up about relational tables has worked. All our workers' CVs have been attached to their records. However, when I had a few spare moments the other day, I noticed that the back end is now approaching 1.5GB. There are only a handful of people using it and all of them are in the same office, so it has been set up as a homegroup with the back end residing on an used pc. I am sure that the size of the database is down to all the attachments and have noticed that some staff have attached jpgs to it as well.
My quandry now is, will going through each individual worker record (now just over 9000 of them) and removing any jpgs reduce the overall size dramatically ,or should I be thinking in terms of adding an extra column to the table and forms etc to have the CVS as hyperlinks? If I go down the hyperlinking route, will that save me much space and would whoever had pulled up the record be able to see the CV etc if they click on the hyperlink? If I do change to hyperlinks, is it easy to do or would it involve coding (which I know nothing about)? I realise that I can't just delete the attachments field until such time as all of the CVs have been hyperlinked if that is the best route to use..
My quandry now is, will going through each individual worker record (now just over 9000 of them) and removing any jpgs reduce the overall size dramatically ,or should I be thinking in terms of adding an extra column to the table and forms etc to have the CVS as hyperlinks? If I go down the hyperlinking route, will that save me much space and would whoever had pulled up the record be able to see the CV etc if they click on the hyperlink? If I do change to hyperlinks, is it easy to do or would it involve coding (which I know nothing about)? I realise that I can't just delete the attachments field until such time as all of the CVs have been hyperlinked if that is the best route to use..