Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-05-2019, 11:21 AM   #1
RogerCooper
Newly Registered User
 
Join Date: Jul 2014
Posts: 139
Thanks: 5
Thanked 11 Times in 10 Posts
RogerCooper is on a distinguished road
Unable to add attachments in linked table

I have found that I can add attachments in the attachment field only if it is native table of the database, but I can't if it is a linked table. Is this a feature of Access or is there a way of doing it?

I can always have the users work with the database containing the table, but it would be easier if there was a linked table.

RogerCooper is offline   Reply With Quote
Old 06-05-2019, 11:23 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 2,541
Thanks: 29
Thanked 626 Times in 609 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Unable to add attachments in linked table

Hi. Without testing it, I am not sure this is correct. How exactly were you attaching the files to the linked table?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 06-05-2019, 01:45 PM   #3
Micron
Newly Registered User
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 581
Thanks: 2
Thanked 114 Times in 109 Posts
Micron will become famous soon enough Micron will become famous soon enough
Re: Unable to add attachments in linked table

you are aware that attachments in Access tables can cause you to quickly reach the db size limit? Often the better method is to store the attachment file path in a table and just let the user call it from some user action such as a button click. The file or folder picker is all that's needed to store/retrieve files and store the path.

__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Micron is offline   Reply With Quote
Old 06-05-2019, 01:51 PM   #4
June7
Newly Registered User
 
June7's Avatar
 
Join Date: Mar 2014
Posts: 1,790
Thanks: 0
Thanked 432 Times in 428 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Unable to add attachments in linked table

It is definitely possible. Not a problem for me.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
Old 06-05-2019, 05:43 PM   #5
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 1,816
Thanks: 17
Thanked 343 Times in 340 Posts
Mark_ will become famous soon enough Mark_ will become famous soon enough
Re: Unable to add attachments in linked table

Roger,

I'll second Micron's post. Also allows you to manipulate the attachment with the program it is intended to work with. Means you can have a word document, open it in word, and allow your end users to update if needed.

Mark_ is offline   Reply With Quote
Reply

Tags
attachment field , linked table

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to use update query with data sourced from a linked table? peskywinnets Queries 5 02-09-2016 02:46 PM
Unable to create a linked table to a .txt file for input to Access IvanSoto Modules & VBA 1 09-03-2012 10:04 PM
Unable to Connect a Linked Table Excel Sheet nanosystems Tables 0 08-13-2011 06:02 AM
Unable to add new records to linked table RexesOperator Tables 2 04-08-2009 01:06 PM
Unable to edit sql linked table dzirkelb General 2 06-05-2008 06:25 AM




All times are GMT -8. The time now is 06:57 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World