Attached Files

[tcheck]

I created a database with an attachment field that is working fine. But for future use, we will be using a SQL database so the attachment field, which is not supported in Microsoft SQL 2005 will become useless for our ASP.Net application. I would like to keep using the attachment filed in access, but I would like to add the actual file name to the table as well without having the user add it.

I can see the attachment FileData, FileName and Filetype when I go into query view, but when I attempt to create an update query that will take the FileName and populate the new field, I get an error that states
Enter Parameter Value with the ReportAttach.FileName below.

Does anyone know how I can get the Filename into a new field?

[June7]

Just went through a lengthy exploration of the Attachment field for another recent thread. It seems an Attachment field cannot be used in Update or Append queries, neither as source nor destination. Have to use VBA to manage. Check thread https://www.accessforums.net/access/...t-15815-2.html