Attachments in Access tables

[Serafina]

Hello,

I want to insert attachments into my table in Access2010 but the program doesn't allow me. When I click to define field as attachment, it is saying:

Operation is not supported for this type of object.

How to make the right type of object? I imported the table from Excell.

Thank you for help!

 

[TimW]

Is your database in Access 2007 or 2010 format? If its 2003 or an MDB format then this, i believe, does not have the attachment datatype.
If the datatype attachment is not in the dropdown box when creating/editing a table then your format is probably an earlier one.
I hope this helps

 

[Serafina]

Thank you a lot!!!
You are right, it is a MDB format. Now I only have to figure it out, how to change it in .accdb

 

[TimW]

I am not sure of the best way but I would open a new .accdb and then drag all the relevant stuff across .. other than that I would have to search the forums

T

 

[CJ_London]

how to change it in .accdb

Select File>Save and publish>.accdb

 

[Serafina]

With Save and publish didn't work (there was no option for new version). At the end I opened new database and imported old one. Now everything is fine and I am happy Thank you for help!