Hi! I'm making an application that connects to an Access database to add/delete/update fields. Now I want to be able to "upload" an image file in the database but I have no idea how I could possibly do that. I made an OpenFileDialog control to be able to select the file I want to put in the database but I don't know how to proceed next... Any help would be much appreciated!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Uploading image in MS Access database
- Thread starter xezekielx
- Start date
It's fairly easy to do (you can basically read the bytes into a parameter and run an insert statement) however as I seem to be saying a lot recently I wouldn't advise using a microsoft access database, especially when images are involved as the database will start to become large very quickly and this is when access starts to struggle. I'd suggest, if possible, looking at alternatives such as the free express edition of SQL Server.
____________________________________________________________
Need help finding an answer?
Try the Search Facility or read FAQ222-2244 on how to get better results.
____________________________________________________________
Need help finding an answer?
Try the Search Facility or read FAQ222-2244 on how to get better results.
- Thread starter
- #3
Uploading images to a database is never a good idea IMHO not even in sql-express. Just save the image somewhere on a shared location and save the path to the database.
But if you really want to then use this
Christiaan Baes
Belgium
I just like this --> [Wiggle] [Wiggle]
But if you really want to then use this
Christiaan Baes
Belgium
I just like this --> [Wiggle] [Wiggle]
- Status
