View Single Post
  #6  
Old January 4th, 2010, 03:42 AM posted to microsoft.public.access.tablesdbdesign
Allen Browne
external usenet poster
 
Posts: 11,706
Default attachment fielad in linked tables

In the front end, delete the attached table.

Then attach it again.

Since Attachment is a multi-valued field, this is what you need to do to get
Access to also attach the super-hidden related table where the attachment
field resides.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Gennady Bronshteyn" wrote in message
...
Did you ever figure out what the problem was? I am having the same issue.

LRidle wrote:

New Attachment field and Linked Table
18-Oct-07

I have just converted an exsiting database to Access 2007 format. It is
split, front end and back end. I have created a new field in a tables
database as an attachment field. If I go to the datasheet view I can add
attachments to the table without any problems. The front end of the
database
that is linked however, doesn't allow me to access the attachment field.
The
option for managing attachments is greyed out in the menu. Is it the case
that you cannot use an attachment field to a linked table, or am I doing
something wrong?

Previous Posts In This Thread:

On Thursday, October 18, 2007 8:59 PM
LRidle wrote:

New Attachment field and Linked Table
I have just converted an exsiting database to Access 2007 format. It is
split, front end and back end. I have created a new field in a tables
database as an attachment field. If I go to the datasheet view I can add
attachments to the table without any problems. The front end of the
database
that is linked however, doesn't allow me to access the attachment field.
The
option for managing attachments is greyed out in the menu. Is it the case
that you cannot use an attachment field to a linked table, or am I doing
something wrong?