Is this possible

[Col]

I'm looking for a way to have a user (real estate agent)add .gif images in their database "access 2000" without having to type any code. Maybe populate a drop down box fed from the images folder. Someone please tell me if I'm way off the mark here or point me in the right direction. "ASPD Enterprise"
Thanks Col F

[Frank]

1. Do not store images directly in any databases. Store the filenames only.
2. If you must store images then do it in SQL class DB and not Access. Use the dbBLOB property to retrieve them.
3. Design a directory structure to allow users to ftp their images intoit and they only need to enter the filenames in the DB.
4. All the other tricks can be done easily like populating drop boxes with images filename that fits a query.


FK



------------
Col at 1/20/00 3:20:16 AM

I'm looking for a way to have a user (real estate agent)add .gif images in their database "access 2000" without having to type any code. Maybe populate a drop down box fed from the images folder. Someone please tell me if I'm way off the mark here or point me in the right direction. "ASPD Enterprise"
Thanks Col F