Android Question Saving Camera Image to MS Access with Jackcess

[Michael Mc]

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]

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?

 

[Michael Mc]

Where is your Access DB located? On your phone? Computer? Where?

Its on the phone.

 

[Erel]

Not sure if that is the best option or if something else would work easier.

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]

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.