A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

New Attachment field and Linked Table



 
 
Thread Tools Display Modes
  #1  
Old October 19th, 2007, 01:59 AM posted to microsoft.public.access.tablesdbdesign
LRidlen
external usenet poster
 
Posts: 2
Default 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?
Ads
  #2  
Old October 19th, 2007, 02:52 AM posted to microsoft.public.access.tablesdbdesign
Allen Browne
external usenet poster
 
Posts: 11,706
Default 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  
Old October 19th, 2007, 03:24 AM posted to microsoft.public.access.tablesdbdesign
LRidlen
external usenet poster
 
Posts: 2
Default 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  
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?


  #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
  #6  
Old January 4th, 2010, 04: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?


  #7  
Old January 4th, 2010, 04:05 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.