Using an iPad to Run Microsof Access
I want to use a small tablet (iPad or Android) to take data and make sketches in the field.
The data will ultimately go into an access database.
Does anybody have a suggestion for an application(s) that make this work.
In particular, I want to be able to use a stylus tom make notes and either a stylus or my finger to check boxes.
Thanks
The data will ultimately go into an access database.
Does anybody have a suggestion for an application(s) that make this work.
In particular, I want to be able to use a stylus tom make notes and either a stylus or my finger to check boxes.
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
;-)
...Especially if your goal is to: Make a sketch, and click a "Send to Database" button...
From the Access side, the difficulties are:
1. You cannot just "put" an image into an Access database remotely.
You must be "In" the database to do this.
2. What Field datatype is the image being stored in? (Attachment, OLE, BLOB, ...etc)
3. What format is the image in? (bmp, jpg, gif, png, ...etc)
4. Will you want to view the image In the database, over the tablet? (what App is associated with the image format)
5. What is the data structure of the images database? One image per record?, multiple images per record?...how will your tablet determine "where" in the database the image gets stored?
The bottom line is that we have may different technologies here (Android OS, IPad (Apple) OS, MS Access (Which needs Windows to run), ...etc)
So unless someone builds a "App" for this, you may be out of luck here for a "simple" solution.
Finally it is not known if this Access database even exits yet.
You say you want to make a sketch (something that must be done "Outside" of Access), ...but you also say that you want to "Check Boxes" (something that must be done "inside" Access)
Access is meant for the desktop, not really for a tablet.
So it is not clear if this database is designed with the appropriate "Touch screen" technology built in...?
JeffCoachman