pleeeeeeease help me!

[anick]

I know there is a lot of posts concerning storage of images in a database. Unfortunately, none seem to answer my specific question.

I posted a question 2 weeks ago, concerning my problem, here it is :

I have a database containing about 2000 pictures and info concerning those images. Once a month, they have to add about a hundred more pictures in the database.

Presently the pictures are stored IN the database. I want to store only the path of the picture. I would like to program something to help them with that process. For example, a button that would find all the images in the folder that are NOT already in the database, and create new records for those images...Ideally, I would do that with a browse button (I already found some code for the browse button, but it seems to work only for one image at a time)

Please, if anyone has an idea of how I can do this...let me know...(I am just a beginner with Access...I usually work with other database programs..)

 

[FoFa]

You would need to develop your own form, with VBA to read the filenames from the folder and compare them to the filenames currently in the DB. Depending on the version you have it differs on how this is done.

 

[anick]

ok...they are using access 2000 on windows 95 (but I'm using access 2000 on win 2000)...

 

[anick]

I managed to program a browse button, but when I try to put the path into a text field, I get "ERROR 3163..." it's saying there is too much character in my field, but I put my text field to 255 characters....I don't understand.

 

[ghudson]

I had a db that had a simular problem. I was not able to use the file browse code if the entire string (Drive:\Path\Filename) was longer than 64 characters. I had to test using the Len function and stop the process if true.

HTH

 

[anick]

I changed the field format from text to memo...but it's still not working because it's not displaying the picture...