Question Locked

How to store a path to image files

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have about 15000 pdf images/files that i need my VB2005 interface to access via an SQL2000 database that contains other attributes. How do i store the pathway to these images in sql? The interface should be able to save the path to the image in sql and also to call and display the image as well. now how do i do it?

2 replies

by tony hopkinson

Personally I'd go for one or the other, doing both the location of the physical file and putting it's content in the DB is just a cock up waiting to happen.

Have image but path is invalid, or worse still points to a completely different file (or an updated version of it,for instance.

Lot of messing about to keep them in sync.
What is the reward?

This discussion is closed to new replies.