J
Jeff Boyce
Thanks in advance for any leads...
This is a "nuts & bolts" question, rather than a general concept question.
(and I've also posted it to the SQL.Programming 'group.)
I've found ('groups, BOL, Microsoft's KB, conversations) that SQL Server has
a datatype (image) that can hold Word documents (or PDFs, or ...). I'm
looking for a way to add zero-to-many "supporting documents" into a SQL
Server table, related to another "parent" table.
No problems with the concepts of relational design, foreign keys, etc. But
I am still fuzzy on how I would, say, run an Access front-end/client,
identify a Word/PDF document, and "add" it into the back-end SQL Server
table. Getting some idea on how I would retrieve it would be nice, too <g>.
Any leads?
This is a "nuts & bolts" question, rather than a general concept question.
(and I've also posted it to the SQL.Programming 'group.)
I've found ('groups, BOL, Microsoft's KB, conversations) that SQL Server has
a datatype (image) that can hold Word documents (or PDFs, or ...). I'm
looking for a way to add zero-to-many "supporting documents" into a SQL
Server table, related to another "parent" table.
No problems with the concepts of relational design, foreign keys, etc. But
I am still fuzzy on how I would, say, run an Access front-end/client,
identify a Word/PDF document, and "add" it into the back-end SQL Server
table. Getting some idea on how I would retrieve it would be nice, too <g>.
Any leads?