Solved

Connect an iPhone app to MS Access DB

Posted on 2011-02-28
15
3,732 Views
Last Modified: 2012-05-11
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!
0
Comment
Question by:LZ1
  • 5
  • 4
  • 3
  • +3
15 Comments
 
LVL 39

Expert Comment

by:als315
ID: 34998207
You can try one of remote desktop clients:
Thinstuff iRdesktop, Jaadu RDP, iTap RDP, WinAdmin etc.
0
 
LVL 30

Author Comment

by:LZ1
ID: 34998246
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
 
LVL 57
ID: 34998458
<<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
 
LVL 19

Expert Comment

by:darbid73
ID: 34998774
Have you had a look at Cellica Database in the iTunes store? see here Linke to Home Page
0
 
LVL 30

Author Comment

by:LZ1
ID: 35003793
@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
 
LVL 3

Expert Comment

by:DockieBoy
ID: 35004685
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
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 35007397
<<@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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 3

Assisted Solution

by:gawhemant
gawhemant earned 250 total points
ID: 35041941
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
 
LVL 30

Author Comment

by:LZ1
ID: 35057680
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
 
LVL 19

Expert Comment

by:darbid73
ID: 35058070
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
 
LVL 57
ID: 35058615
<<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
 
LVL 19

Expert Comment

by:darbid73
ID: 35059369
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
 
LVL 30

Author Comment

by:LZ1
ID: 35059394
So then it can't be done?  
0
 
LVL 57
ID: 35059576
<<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
 
LVL 30

Author Comment

by:LZ1
ID: 35059589
Thank you Jim.  Your points are then still very well deserved!  

I appreciate all of the follow ups!!!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now