New Attachment field and Linked Table

[LRidlen]

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?

 

[Allen Browne]

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]

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]

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.

 

[Gennady Bronshteyn]

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:

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?

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 Australi
Tips for Access users - http://allenbrowne.com/tips.htm
Reply to group, rather than allenbrowne at mvps dot org


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

:

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 Australi
Tips for Access users - http://allenbrowne.com/tips.htm
Reply to group, rather than allenbrowne at mvps dot org



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

 

[Allen Browne]

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

Reply to group, rather than allenbrowne at mvps dot org.

in message
news:[email protected]...

 

[Jeff Boyce]

Gennady

In addition to Allen's suggestion of re-attaching the linked table, could
you confirm that you are using the .accdb format (Access 2007 data model)
rather than the (default) Access 2003 (.mdb) format?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.