Attach a file to an recordset?

[radubalmus]

Hy,
I am using VBA(and ADO) and i want to attach a file to a database recordset(i am using sql server database).
Never done this before.
I need some pointers, examples, links to get started
Thanks in advance

There are simple solutions for almost every problem! The hard part is to see them!!!!

 

[rcloutie]

Hi,

Create a field as varchar(255) and save the access path.

Of course, if a user moves the file within explorer, the path becomes invalid. That's the reason why we have to develop a home made explorer in which we can make all validations needed according to the enterprise's rules.

Hope this helps,

RC

 

[onpnt]

Can you explain what you mean by "attach a file to a database recordset". That doesn't make any sense to me

Are you saying you want to insert a file into a table in the database? You cannot "attach" anything to a recordset. Aside from that if you're question after explained is truly a VBA question you need to post in that forum

[sub]____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]

 

[radubalmus]

i was meaning exactly that(somethin like attaching a file to a mail).

I was thinking it can be done(i am not an expet => that's why i am posting here).



There are simple solutions for almost every problem! The hard part is to see them!!!!