Split database cannot create a field with attachment (1 Viewer)

[georg0307]

Dear All,

I need to create into the table "TabellaBase" an attachment field, unfortunately seems impossible, because the field propriety don't suggest "Attachment", in italian Allegato.

in attachment you'll find the Backend of a split Database.

could you please help me on this matter?

Is there a different way to attach Multiple images to new records created?

Thanks in advance!!!

Best regards,
Georg

 

[arnelgp]

convert your db to .accdb then modify the table and replace Photo as Attachment.
i think you also need to convert the FE to .accdb?

better create a backup first (both FE and BE).

be warned that adding attachment field will bloat your db.

 

[arnelgp]

Is there a different way to attach Multiple images to new records created?

create another table that will save all images (you can use OLE and need not change to .accdb).
add FK field.
create a subform based on this table.

 

[arnelgp]

Is there a different way to attach Multiple images to new records created?

you can even have a short text field and save the physical location on disk of the image
rather than embedding it in the db.

 

[Pat Hartman]

As @arnelgp said, storing ANY image in a table regardless of the data type will bloat the database. A better option as arne finally got to is to just store the path to the object.

Also, Attachment is a specifically ACE data type. If you think you might ever want to convert the BE to SQL server or some other RDBMS, do not use that or any of the other datatypes added with A2007. None of them are compatible with SQL Server.