Creating a web application for android that connects to a Microsoft Access database

[deucalion0]

I want to create an Android application where a user can create an account which basically stores their username and password, and photos. I want to use a Microsoft Access Database, a user once logged in can take a photo using the android device and the photo is automatically sent to the database and stored under the user account. I don't want to use the internal SQL lite database, the whole aim of this is to store photos taken on a server as opposed to the device.

If I have an access database created on my server, is it possible to accomplish this?

[jbennet]

1) Dont use access. It has crap locking and transaction support, if you have multiple users accessing remotely (as you will do) it will not work.
2) Dont save the file in the DB itself, upload it to your server somehow, and then save the PATH to the file in the DB.

Ive done a similar thing to get an android app writing some data to an Oracle DB.

I basically had the Android APP POST over HTTP whatever it wanted to save as JSON to a Java Servlet running on my web server, which handled the actual database interaction.

[deucalion0]

jbennet thanks for your reply, Basically Access was the only way I could think of doing it, I suppose my question should have been which is the best way to do it. So if I can figure out how to send data to a folder in my server instead? This may be too complex for me after all. :(

[jbennet]

Yes just send the data using the POST method over HTTPS - and have your web code handle putting that in the database. - the code on the web side for doing this would be no different to if it was getting the data from, say, an HTML form.

[deucalion0]

I have been trying to do this all day, upload files to a folder on my server using a secure ftp connection, but I cannot figure out how to do this using HTML. I usually just connect manually using FileZilla, trying to do this any other way seems impossible.

Any thoughts?

I just want to upload files to my server, I know I can link to that folder from within my database, then I should be finished.

[jbennet]

Dont use FTP - POST it as binary data over HTTP.

[deucalion0]

Sorry being really stupid, but I have no idea how to connect to a folder on my server, I only know how to access my server using FTP, I shall have to research your suggestion see if I can see an example!! Thanks!!!!!

[jbennet]

You dont connect to a folder.

Take a normal web signup page, for example, right?

In that case, you would have a plain HTML form which POSTS some data (username, whatever) to some web code to handle the database interaction.

its the same. You just need to POST the expected fields from the phone to a web app (posting the image as a binary file is the difficult bit), and let the web server handle what to do with the data once it gets it (i.e. save image away somewhere, insert associated data into database)