Application to Allow Data Entry to an Access Database from an Android Tablet
Looking for an application that works as a template allow input on an android table that can be imported into an access database?
May or may not have internet connection at the time data is taken in the field
May or may not have internet connection at the time data is taken in the field
Well the "easy" way would be to develop such an application that writes your data to SQLite( i am not aware about other Android database engines) and then sync this file to your desktop/import it to Access...(manually)
The "harder" way would be that your application talks to an SQL server that has a linked server to your Access...again use SQLite for tempdb but depending on connectivity sync the data .
The "harder" way would be that your application talks to an SQL server that has a linked server to your Access...again use SQLite for tempdb but depending on connectivity sync the data .
ASKER
Recovering from a computer crash - will be a few days before i get back to this
Thanks for the suggestions
Thanks for the suggestions
Let's give this a little bit longer and see if roger comes back to this.
Would like to explore it a little bit more with him.
I'm not sure either of our comments really fits.
Jim.
Would like to explore it a little bit more with him.
I'm not sure either of our comments really fits.
Jim.
ASKER
Sorry things have been nuts the last few weeks
I will revisit this over the weekend
I will revisit this over the weekend
ASKER
Never did find a solution - time has passed
Any new ideas?
Any new ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THanks
Guess I'm not surprised
Guess I'm not surprised
Well you have some "solutions".
The obvious solution is to use some kind of "bridge" in terms of using another database engine that can "listen " get the data and push (or pull) them to your Access application.
Another solution would be by utilizing some web technology , pushing the data and have Access pull the data.
There is a third solution (maybe) by turning Access to "listen"...it is something i toyed some time ago but it would require some work to make it functional and probably it wouldn't worth the time/effort.
The obvious solution is to use some kind of "bridge" in terms of using another database engine that can "listen " get the data and push (or pull) them to your Access application.
Another solution would be by utilizing some web technology , pushing the data and have Access pull the data.
There is a third solution (maybe) by turning Access to "listen"...it is something i toyed some time ago but it would require some work to make it functional and probably it wouldn't worth the time/effort.
Lot's of apps out there with just a quick check of the Google store along the lines of this:
http://www.fulcrumapp.com/uses/field-data/
What I'd suggest is finding an app first and focusing on that, and not worry about the Access part for the moment (and this is the main reason for commenting). Just make sure the app can output in either CSV (text file) or XLS (spreadsheet), or has a web API that you can interact with. Access can work with any of those easily enough for the importing of data.
Jim.