Check the status of attachments in the database

[eugenewright]

Hi guys, How to check if file is stored in attachment field? What I want is that when uploading an attachment for a document there should be an output status column of "Completed". This is very convenient.
Does anyone know how to use the query? Thanks!

[Knobbi38]

Hello,

Attachments are provided as recordsets in a DAO.Recordset2. This can be opened and then you can determine the number of records in the recordset.


For an example of access, see here:
https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/recordset2-object-dao