MS Access to SQL Server Image

0 pts.
Tags:
T-SQL
VBA
I have a Sql Server 2000 database. We don't have Web resources available, so I must write a User Interface in MS Access 2003. What I want to do is have the user supply a path and name for a document. Then I want to load the document into the Image field of the SQL Server DB. I have found some code online that uses addchunck, but it does not work in MS Access 2003. I can Drag and drop the files into the field if it is in the datasheet mode, but that is real ugly. I will also have to extract the document for viewing by the user. All of the documents are MS Word. Can anyone help with a MS 2003 explanation of the process? Thanks Don
ASKED: November 11, 2005  10:45 AM
UPDATED: November 14, 2005  1:11 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Well, since the chunk method has worked since at least Access 2.0, and is still viable in VB.Net, it should be viable in VBA 2003. So, it would seem you’re on the right track, although there are quite a number of variations of that code for different languages/versions. That means you may have to tweak your code a bit to make it work.

There are also certain limitations that aren’t always mentioned, such as the blob fields needing to be at the end of the SELECT list. And occasionally bugs crop up that prevent particular combinations of apps/OS’s from playing nicely together. (As I recall, NT 4.0 had some issues along these lines…probably a driver issue, although I don’t remember the details.)

So, if you got this code online, it almost certainly works for SOME combination. Give us the URL and maybe we can help tweak it into working order. It would also be extremely helpful to know what error you’re getting, and on what line of code it occurs.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following