Doug Murphy
dw-murphy at cox.net
Tue Jan 19 16:23:58 CST 2010
Thanks Dan, My approach exactly. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Tuesday, January 19, 2010 2:18 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2007 attachment fields- Any knowledge? As an experiment, make a copy of the table and delete the attachment field column. Then use that as the data source for this form. Does it speed up? On a separate note - my systems may also attach one or more files per record. What I've learned to do is to only store the file name in the table. Then when someone wants to open that file, I build the full path in code (using stored values), then open it using FileSystemObjects. That way, as does happen, if the path changes you can just change the parameters which define the path, and your data and code are already good to go. Good Luck! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: Tuesday, January 19, 2010 4:07 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Access 2007 attachment fields- Any knowledge? Folks, I have had several questions recently re Access 2007. This latest project has been pushing me into some of it's newer features(?). The person who originally developed this application used attachment fields to hold stored documents. The form that has controls linked to these fields is very slowwwwwwwwwwww to open, close, update, you name it. It is also slow to open and work with in design mode. Do any of you listers have any experience with this type of field? My personal preference would be to not use them and store hyperlinks to the files in a hyperlink field. This would be much more straight forward in my simple minded world, and more maintainable. Tell me if I am missing the point with this data type. Any links to meaningful articles on using this data type would be appreciated. Thanks. Doug -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com