Prev: Any advice? Creating forms on the fly
Next: HTML to RTF Access
From: szag via AccessMonster.com on 8 Apr 2010 09:39
I haven't use the attachement data type before.

I set up a field in my BE tables as an attachment data type. I placed this
field in my FE form, but when I right click on the field the "Manage
Attachments" and all other options on the shortcut menu are greyed out. Any
ideas?

--
Message posted via http://www.accessmonster.com

From: Allen Browne on 8 Apr 2010 10:40
Delete the attached table in the front end.
Compact.
The attach the table again.

Attachments are multi-valued fields, and use a super-hidden link table
that's not visible anywhere in the database. The link data doesn't have this
super-hidden table linked. Destroying the link, and then linking it again
should solve the problem.

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


"szag via AccessMonster.com" <u2885(a)uwe> wrote in message
news:a639b16361718(a)uwe...
> I haven't use the attachement data type before.
>
> I set up a field in my BE tables as an attachment data type. I placed this
> field in my FE form, but when I right click on the field the "Manage
> Attachments" and all other options on the shortcut menu are greyed out.
> Any ideas?

From: David W. Fenton on 8 Apr 2010 18:57
"Allen Browne" <AllenBrowne(a)SeeSig.Invalid> wrote in
news:#BUytly1KHA.140(a)TK2MSFTNGP05.phx.gbl:

> Attachments are multi-valued fields, and use a super-hidden link
> table that's not visible anywhere in the database. The link data
> doesn't have this super-hidden table linked. Destroying the link,
> and then linking it again should solve the problem.

Is there any way to enumerate these "super-hidden" table links?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
From: Allen Browne on 9 Apr 2010 00:11
"David W. Fenton" <XXXusenet(a)dfenton.com.invalid> wrote in message
news:Xns9D54C0EAC6FDAf99a49ed1d0c49c5bbb2(a)74.209.136.92...
> "Allen Browne" <AllenBrowne(a)SeeSig.Invalid> wrote in
> news:#BUytly1KHA.140(a)TK2MSFTNGP05.phx.gbl:
>
>> Attachments are multi-valued fields, and use a super-hidden link
>> table that's not visible anywhere in the database...
>
> Is there any way to enumerate these "super-hidden" table links?

Not that I'm aware of, David.

From memory, you can actually see them referenced in some of the hidden
system tables that deal with complex columns -- was it MSysComplexColumns?

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




 | 
Pages: 1
Prev: Any advice? Creating forms on the fly
Next: HTML to RTF Access