Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 21st, 2016, 04:15 AM
Authorized User
Join Date: Feb 2011
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Attachment datatype

Access 2013 offers the possibility to create 1 or more fields with the ATTACHMENT datatype. Looks very interesting and works when I handle directly in the "main" table, including forms when active in same data-file.
As we have built a multi-user application, our main tables are "linked" to our user application-file.
Building a form in this "application"-file doesn't give access to the attachment-type-fields and possibilities. As multiple "docs" are used by different users, such a field is (for us) an optimal solution.
Any ideas why it doesn't work?
Thanks for any suggestion

Old January 30th, 2017, 09:31 PM
Friend of Wrox
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts

After some experiments with them, I have always avoided the attachment data type for desktop databases. There are many posts from people having issues with it. I have also had lots of issues with them in Desktop databases.

It is my understanding that the Attachment datatype was added to help with Microsoft's first attempt at as having Access publish to a Sharepoint server with a Web browser based front end.
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Similar Threads
Thread Thread Starter Forum Replies Last Post
Maximize Attachment With Open Attachment Button irritable_badger BOOK: Access 2007 VBA Programmer's Reference ISBN: 978-0-470-04703-3 0 February 12th, 2009 12:25 PM
datatype umeshtheone SQL Server 2000 2 May 16th, 2007 11:56 AM
SQL Datatype rain_uk SQL Server ASP 2 July 5th, 2005 01:34 AM
DataType Conversion using WHERE IN ( ) Colonel Angus SQL Language 3 August 18th, 2004 07:43 AM
datatype ngang SQL Language 1 November 18th, 2003 09:55 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.