Connect an iPhone app to MS Access DB

Hey Experts!!

I'm not sure if it's even possible, but can I connect to a Microsoft Access 2003 DB through an iOS app? Or should I convert everything to MySQL?  The problem with converting is that they are so heavily invested into the MS Access DB with an intranet right now.  

Any and all suggestions are welcomed!
LVL 30
LZ1Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
<<@JDettman: There will be updating/editing to these records.  The eqldata link you provided is nice, however they wanted everything to be done inside of the app.  The ultimate goal is to have the client install this app on their iPhone/iPad/iPod. Then update their information via the app, which would ultimately write it back to our DB on our own server.  >>

  Ah, your tackeling it a bit differently then; it's not remote access that your looking for, but the ability to work off-line.

  Unfortunately, replication was dropped from JET starting with Access 2007, which might have been a solution (not sure if you could get Access to run on an iPhone).

  You do get that with SharePoint 2010 and Access 2010, but I know of no one that's using that feature yet in production and being that it is brand new, there are bound to be some issues with it.  

  Again, on top of that, I don't know that you'd get Access or JET to run on an iPhone.

  I am a bit surprised at the approach your taking.  Most simply go for remote access via a mobile device as keeping a db local on a phone and then synching would bring up a number of issues.

JimD.


0
 
als315Commented:
You can try one of remote desktop clients:
Thinstuff iRdesktop, Jaadu RDP, iTap RDP, WinAdmin etc.
0
 
LZ1Author Commented:
What they're actually thinking of is developing an app that the client can connect to the DB and view all of the information
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<What they're actually thinking of is developing an app that the client can connect to the DB and view all of the information >>

  You can continue to use JET for a data store and write a front end in something like ASP.net.

  Another option to look at is Sharepoint 2010 with Access services, which lets you put web enabled Access DB's on a share point site.

  Last, you might want to look at this:

  www.eqldata.com

  Which let's you put an Access DB on the net basically un-modified.  Don't know anyone that's used them yet, so if you decide to try them out, would really like some feed back.

  Last, Terminal Services has been mentioned, but if you through Citrix Access Essentials on top of that, then you can access un-modified Access apps via any web browser.

JimD.
0
 
darbid73Commented:
Have you had a look at Cellica Database in the iTunes store? see here Linke to Home Page
0
 
LZ1Author Commented:
@JDettman: There will be updating/editing to these records.  The eqldata link you provided is nice, however they wanted everything to be done inside of the app.  The ultimate goal is to have the client install this app on their iPhone/iPad/iPod. Then update their information via the app, which would ultimately write it back to our DB on our own server.  

Please forgive my ignorance to the subject, I'm a front-end developer not a programmer by any means.

Overall it seems like it can be done, unless I'm mistaken(in which please let me know).  There may be some additional leg work that has to be done in order for everything to work correctly, but I'll cross that bridge when I come to it.
0
 
DockieBoyCommented:
I had a brief look at Celica Database (I think it is called), an iPhone app, but have not played with it yet, from what I saw, looks like a fair bit of work, but might do the job.
0
 
gawhemantConnect With a Mentor Commented:
You should write a web Service which will connect to the database, and your iPhone app should be making calls to the web Services.
I have implemented it in various application.Actually we are having centralized database for our website/windows application/iPhone app.
You can get the result in XML format and parse the data using parser methods in objective-C.
0
 
LZ1Author Commented:
So it seems the bottom line is this: The only way to connect to an MS Access 2003 DB is to use Objective-C. If that can happen, I can't use JET or Access on the iPhone itself.

I understand that the client app is dated and the request seems a bit silly.  But I had to ask.  

Thanks everyone!
0
 
darbid73Commented:
I am not sure you have covered it all.  There are a number of ODBC solutions and that means a direct connection to a database.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<I am not sure you have covered it all.  There are a number of ODBC solutions and that means a direct connection to a database. >>

  While ODBC may be available, I don't know how you get JET to actually run on the phone as JET is composed of Windows based DLL's.

  And since JET internally has never been documented, it's not even possible to write something to replace it and deal with the file directly.

JimD.
0
 
darbid73Commented:
I was thinking and I must add from Theory as I have not tried it something like this -

here is a link to an ODBC SDK - LINK

Here is how to remotely access MSAccess. - LINK
0
 
LZ1Author Commented:
So then it can't be done?  
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<So then it can't be done?   >>

  I don't see how.  Sure you can access it from the phone remotely via a browser, but to get a MDB (JET based DB) used right on the phone?  No.

Jim.
0
 
LZ1Author Commented:
Thank you Jim.  Your points are then still very well deserved!  

I appreciate all of the follow ups!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.