Storing binary data in MS Access database -- what do you think?
-
Hi there, I'm coding a photo gallery desktop program and I'm planning to store the images in an MS Access DB (OLE field). The size of the images I got is around 600 MB... ~ 400 KB each. What do think? Can MS Access handle it or I should look for an alternative? Please advise. Your help would be greatly appreciated.
-
Hi there, I'm coding a photo gallery desktop program and I'm planning to store the images in an MS Access DB (OLE field). The size of the images I got is around 600 MB... ~ 400 KB each. What do think? Can MS Access handle it or I should look for an alternative? Please advise. Your help would be greatly appreciated.
instead of storing the binary data in the access database store the location to the data. Either file names or URLs. I think such large amounts of data in access could cripple it. A man said to the universe: "Sir I exist!" "However," replied the Universe, "The fact has not created in me A sense of obligation." -- Stephen Crane