Can I create a control to open a file dialogue box to select an image to save to DB?

[Leopardfist]

I am using Access 2000 for my database, and I am wanting to know if there is a way I can create a button on my form for someone to click, that will open a browse for file window and let them choose an image to save to that file in the database. All images are in BMP format.

Any and all help with this is greatly appreciated.

 

[RuralGuy]

I would strongly recommend against saving an image in an ac2k db because of the bloat but many developers use this API to open the Windows File Open/Save dialog.

 

[Leopardfist]

OK, if I wanted to do it in a different way, how could I do it?

My images are all going to be in a folder titled "Pics" that is actually in the directory of the Database on my server. I have never messed with images in a DB before, so I know nothing about it.

Can you walk me thru what controls to use in order to allow a normal user to enter the info (file location) of the image, and then how I actually make the DB display this image without it being saved into the DB?

 

[RuralGuy]

Look at the Employee's form in the Northwind sample db that comes with Access for a method to display the pictures. Larry Linson also has a sample db that demonstrates three different methods.