Android Question Saving Camera Image to MS Access with Jackcess

Michael Mc

Member
Licensed User
Longtime User
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
I need to save a camera picture to my Microsoft Access Database using Jackcess
Where is your Access DB located? On your phone? Computer? Where?
 
Upvote 0

Erel

B4X founder
Staff member
Licensed User
Longtime User
Upvote 0

Michael Mc

Member
Licensed User
Longtime User
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
Top