Hi everyone. First off, apologies if that's been asked and solved before, which it probably has. I've searched the forums a bit and couldn't find a fitting thread.
I had a 'big' table with around 50 fields and I'm in the process of 'modularizing' it. I have created two new tables that will contain records with related fields from the original table. The problem is that two of those fields are attachment fields with consent pdfs and other related data. Obviously Access doesn't allow the inclusion of this type of multivalue fields in an Update query. So I though about moving them manually, since it's just about 150 records on the original table (hell of a work, considering it's 2-4 attachments per record, but still). Thing is it's constantly giving me 'file is not secure' or 'file is too big' errors with files that are already attached to the original table which makes no sense (specially since if I copy the file it will let me add it despite being the same size).
So, is there any easy and painless way of doing it? My first option would be doing it programmatically, but that would require saving the attachments somewhere and reattaching them to the new table, then clean all the old attachements which are in very specific net shares' locations. Is there any way I can somehow access the path of the original attachments from the attachment field and set the same path in the attachment field of the new table (or at least use it to save the files I recover from the attachment field in the corresponding folder)?
Second option would be including a path and not an attachment, but I'd prefer the files to be in the DB since it's a pretty small DB (currently under 100MB) and I'd rather have the files on the db than just a simple path.
Thanks!