Peter, I have a database that has a table in it that really inflates so what I did is moved it in to its own back end. It worked so well that I have a front end database that has 3 back ends.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ka0t1c_ang3l
Sent: Thursday, May 29, 2014 9:36 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: List of Attachements
Thank you all for your help!
Peter,
I did the compact and repair database as you recommended, and it did compact the database and brought it down to 1.01 GB; however, it's still large. Instead of using the attachment field, could I just type in the name of the document, and have a hyperlink that would open the document from a network folder? If so, how would I do that? And, could I then add in a date/time field for each of those hyperlinks that would show the date the item was added? And could I then have the list and timestamp added to my compliance report?
Thanks!!!
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (18) |
Tidak ada komentar:
Posting Komentar