Search results

Thanks for that Micron (eye rolling noted). When the external folders get hyperlinked they state the full path name in the hyperlink field, which is not related to the dB storage location. They are just on the same drive. The dB and folders will be provided to the user in one folder, with...

Thanks again for that. The other option I have is to simply get the end user to do a universal "Find and Replace" on the hyperlink table, to change the drive letter and any other file information to suit them. I have never programmed in the Access environment, which I imagine 90% of users don't...

Thanks for your quick reply. My database is to be distributed to users who may know less about ACCESS than I do. I want to avoid programming and I want to avoid multi-step operations that require a deeper understanding of the program. The attachment option appealed at first because I could...

To keep my dB under 2Gb I have created a hyperlink field that directs to a series of folders containing hundreds of pdfs. Keeping the pdfs as attachments in Access blew the file size. My problem is that when I transport the database and linked folders to a new location, ie to a clients...