Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Attach a file to an recordset?

Status
Not open for further replies.

radubalmus

Programmer
Apr 26, 2007
49
EU
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!!!!
 
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
 
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]
 
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!!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top