Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old October 21st, 2016, 04:15 AM
Authorized User
Points: 100, Level: 1
Points: 100, Level: 1 Points: 100, Level: 1 Points: 100, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2011
Location: Belgium
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Skype™ to Cram
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
Reply With Quote
  #2 (permalink)  
Old January 30th, 2017, 08:31 PM
Friend of Wrox
Points: 1,012, Level: 12
Points: 1,012, Level: 12 Points: 1,012, Level: 12 Points: 1,012, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 244
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
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 11:25 AM
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 08:55 AM



All times are GMT -4. The time now is 02:42 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.