I've created a database using DAO 3.6, with a table containing a field named "Data" of the type dbLongBinary (this worked with byte arrays, so it was the most logical option to me).
I want to write a User Defined Type to the "Data" field, but when I use:
RS("Data") = tData
(tData is the UDT defined in a module as public, and is used several more times without any errors, so it's not the declaration)
But when I use the method above, it gives me an error: "Only user-defined types defined in public object modules can be coerced to or from a variant or passed to late-bound functions".
I don't want to split up the UDT in several fields and load it that way, does anybody know how to make this work?