1,105,625 Community Members

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

Member Avatar
deucalion0
Junior Poster in Training
62 posts since Mar 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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?

Member Avatar
jbennet
Moderator
17,127 posts since Apr 2005
Reputation Points: 1,618 [?]
Q&As Helped to Solve: 736 [?]
Skill Endorsements: 38 [?]
Team Colleague
Featured
 
1
 

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.

Member Avatar
deucalion0
Junior Poster in Training
62 posts since Mar 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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. :(

Member Avatar
jbennet
Moderator
17,127 posts since Apr 2005
Reputation Points: 1,618 [?]
Q&As Helped to Solve: 736 [?]
Skill Endorsements: 38 [?]
Team Colleague
Featured
 
0
 

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.

Member Avatar
deucalion0
Junior Poster in Training
62 posts since Mar 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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.

Member Avatar
jbennet
Moderator
17,127 posts since Apr 2005
Reputation Points: 1,618 [?]
Q&As Helped to Solve: 736 [?]
Skill Endorsements: 38 [?]
Team Colleague
Featured
 
1
 

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

Member Avatar
deucalion0
Junior Poster in Training
62 posts since Mar 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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!!!!!

Member Avatar
jbennet
Moderator
17,127 posts since Apr 2005
Reputation Points: 1,618 [?]
Q&As Helped to Solve: 736 [?]
Skill Endorsements: 38 [?]
Team Colleague
Featured
 
1
 

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)

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article