Michael Mc Member Licensed User Longtime User Nov 16, 2017 #1 Hello people, I need to save a camera picture to my Microsoft Access Database using Jackcess. I was hoping that someone had already done this and could supply me with code to do so. I have been searching around and have not found anything on it. I'm using an OLE Object field in the MS Access Database to store the photo. Not sure if that is the best option or if something else would work easier. I just wanted to use the OLE field so users will have a standard field to the picture within Access. Thanks in advance.
Hello people, I need to save a camera picture to my Microsoft Access Database using Jackcess. I was hoping that someone had already done this and could supply me with code to do so. I have been searching around and have not found anything on it. I'm using an OLE Object field in the MS Access Database to store the photo. Not sure if that is the best option or if something else would work easier. I just wanted to use the OLE field so users will have a standard field to the picture within Access. Thanks in advance.
OliverA Expert Licensed User Longtime User Nov 16, 2017 #2 Michael Mc said: I need to save a camera picture to my Microsoft Access Database using Jackcess Click to expand... Where is your Access DB located? On your phone? Computer? Where? Upvote 0
Michael Mc said: I need to save a camera picture to my Microsoft Access Database using Jackcess Click to expand... Where is your Access DB located? On your phone? Computer? Where?
Michael Mc Member Licensed User Longtime User Nov 16, 2017 #3 OliverA said: Where is your Access DB located? On your phone? Computer? Where? Click to expand... Its on the phone. Upvote 0
OliverA said: Where is your Access DB located? On your phone? Computer? Where? Click to expand... Its on the phone.
Erel B4X founder Staff member Licensed User Longtime User Nov 19, 2017 #4 Michael Mc said: Not sure if that is the best option or if something else would work easier. Click to expand... Using MS Access as a database is never the best option. I don't know whether Jackess supports blobs. Convert a bitmap to bytes: https://www.b4x.com/android/forum/threads/b4x-bytes-to-file.70111/#post-445167 Upvote 0
Michael Mc said: Not sure if that is the best option or if something else would work easier. Click to expand... Using MS Access as a database is never the best option. I don't know whether Jackess supports blobs. Convert a bitmap to bytes: https://www.b4x.com/android/forum/threads/b4x-bytes-to-file.70111/#post-445167
Michael Mc Member Licensed User Longtime User Nov 19, 2017 #5 I was able to get this to work. Yes Jackcess works with blobs in OLE Object Fields. I'll post code for others, once I clean it up after all the testing. I'm very impress with how easy this library works. Super easy moving a database file back and forth between the desktop and the Android device. I don't have to write code to work the data back on desktop because MS Access has already done the dirt work for me. I understand that MS Access format is not native to Android but for my purposes it works well. Saved days writing a front end to on the desktop to deal with Sqllite. Upvote 0
I was able to get this to work. Yes Jackcess works with blobs in OLE Object Fields. I'll post code for others, once I clean it up after all the testing. I'm very impress with how easy this library works. Super easy moving a database file back and forth between the desktop and the Android device. I don't have to write code to work the data back on desktop because MS Access has already done the dirt work for me. I understand that MS Access format is not native to Android but for my purposes it works well. Saved days writing a front end to on the desktop to deal with Sqllite.
