I upsized my Asset Template .accdb to SQL Server 2008. Every field except the Attachments works as expected.
I tried changing the datatype of the Attachments field in the SQL Server table, no types would get the Attachments field to work.
We don't have the time to spend coding VBA to handle attachments ourselves (possibly with storing the path to the file in the db and making our own upload form).
Is there any way to utilize the Attachment handling Access provides with SQL Server?
Any thoughts are appreciated.
I tried changing the datatype of the Attachments field in the SQL Server table, no types would get the Attachments field to work.
We don't have the time to spend coding VBA to handle attachments ourselves (possibly with storing the path to the file in the db and making our own upload form).
Is there any way to utilize the Attachment handling Access provides with SQL Server?
Any thoughts are appreciated.