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

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

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.