Question

differentiate between OLE object and attachment in ms access​

Answer 1

Explanation:

The Attachment data type, introduced in Access 2007, is very similar to the OLE Object data type in that you can use it to store complex data. However, unlike the OLE Object data type, you can store multiple attachments in a single record. These files are stored in a binary field in a hidden system table.

Answer 2

Answer:

Answer:The Access Attachment data type is limited to Microsoft Access databases. The OLE Object data type can be migrated to an SQL Server database where the content within the stored documents can be searched with an SQL Server query.

hope helped ☺☺

happy learning