View Single Post
  #5  
Old January 3rd, 2010, 06:10 PM posted to microsoft.public.access.tablesdbdesign
Gennady Bronshteyn[_2_]
external usenet poster
 
Posts: 1
Default attachment fielad in linked tables

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?

On Thursday, October 18, 2007 9:52 PM
Allen Browne wrote:

Just tried, and did not have a problem.
Just tried, and did not have a problem.

Using A2007, I opened an ACCDB and linked a table from another ACCDB. The
linked table has an Attachment field. Opening the linked table in datasheet
view, I was able to add and delete attachments okay.

Was your case different?

--
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.

"LRidlen" wrote in message
...

On Thursday, October 18, 2007 10:24 PM
LRidle wrote:

no, I did exactly the same thing....
no, I did exactly the same thing.... the only difference might be that my
database was previously in A2003. The linked table acts like the field is
locked in the front end.

"Allen Browne" wrote:

On Friday, October 19, 2007 3:48 AM
Allen Browne wrote:

Is the back end still an A2003 format file?
Is the back end still an A2003 format file?
If so, it cannot have an Attachment field in it.

If your front end thinks there's an attachment field there, it might be
worth unchecking the Name AutoCorrect boxes and then compacting the
database.

Otherwise the problem could be a concurrency issue if Access thinks the
table is currently locked.

--
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.

"LRidlen" wrote in message
...


Submitted via EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .NET Tips and Tricks #17
http://www.eggheadcafe.com/tutorials...-cool-net.aspx