What is the data model for an attachment?

S

Stewart Berman

when you add an attachment field to a table an entry is made in MSysObjects for a table with what
looks like f_ plus a GUID. They Type is 1 which is supposed to be a local table but no such table
exists. The parent id is 251658241 which is Tables but there isn't any tabledef for it.

There is an entry for the attachment field in MSysComplexColumns but the FlatTableID points back to
f_GUID table.

Queries that work on a normal table (a delete using a joint on primary keys) fail on a table with an
attachment.

So where do attachment fields fit into the Access 2007 data model?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Creating a Chart on form from selected data in query. 0
Cannot sort a table containing text 5
How to use MS Access .jpg attachment in MS Word Mail merge 0
Pulling data from a linked SQL table 2
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Expaning a word document in Access 2007 using an attachment 0
Access 2007: where is the data related to multi-valued fields stor 3

Top