View Single Post
  #4  
Old October 19th, 2007, 08:48 AM posted to microsoft.public.access.tablesdbdesign
Allen Browne
external usenet poster
 
Posts: 11,706
Default New Attachment field and Linked Table

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

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?

"LRidlen" wrote in message
...
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?