Morning All
I started a thread earlier on how best to manage my data because we are going to reach data limits soon (https://www.access-programmers.co.uk/forums/showthread.php?t=308028)
Currently there is an attachment field on the form which is heavily being used. What I need to do is remove the attachments from the database and have them stored on the network instead, but look and behave as close to the attachment box as possible. There will be multiple attachments per form in multiple formats.
To add more pain to this, each person has their network drives mapped differently so will need it use the either the server name or its IP as part of the save / hyperlink / retrieve function.
I really don't know where to start with this so any help is seriously appreciated.
I managed to shrink the backend down to 1.1GB so buy some time while this is completed.
Thanks,
Cat
I started a thread earlier on how best to manage my data because we are going to reach data limits soon (https://www.access-programmers.co.uk/forums/showthread.php?t=308028)
Currently there is an attachment field on the form which is heavily being used. What I need to do is remove the attachments from the database and have them stored on the network instead, but look and behave as close to the attachment box as possible. There will be multiple attachments per form in multiple formats.
To add more pain to this, each person has their network drives mapped differently so will need it use the either the server name or its IP as part of the save / hyperlink / retrieve function.
I really don't know where to start with this so any help is seriously appreciated.
I managed to shrink the backend down to 1.1GB so buy some time while this is completed.
Thanks,
Cat