If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
New Attachment field and Linked Table
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 ... 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? |
#3
|
|||
|
|||
New Attachment field and Linked Table
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? -- 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 ... 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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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? |
#7
|
|||
|
|||
attachment fielad in linked tables
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. 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? 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 |
Thread Tools | |
Display Modes | |
|
|