I have 10 thousand records in a table. each record has two attached files in single attachment field.
my requirement is to save all the attached files from all records to local drive in one go.
how can I perform this action in Access 2013 64 bit
I have 10 thousand records in a table. each record has two attached files in single attachment field.
my requirement is to save all the attached files from all records to local drive in one go.
how can I perform this action in Access 2013 64 bit
I have never saved documents in the BE. But I Googled
saving data from Attachment field to local drive
and found this: http://www.access-programmers.co.uk/...d.php?t=228146
Maybe it will help. Be sure and read the whole thread......
Hopefully this will help. https://www.accessforums.net/access/...eld-40827.html
The link in post 2 seems to have gone bad but download the example in post 5.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I believe that example will require an additional loop (code) to iterate the attachment field since the user stated there is more than one attachment in a given field.
thanks ssanfu this resolved my issue
Thanks ssanfu this resolved my issue
Thanks to all of you,
you guys are great