question about data base managment

Discussion in 'Productivity Apps Forum' started by Sebita2305, Jan 17, 2013.

  1. Sebita2305
    Offline

    Sebita2305 iPF Novice

    Joined:
    Jan 16, 2013
    Messages:
    13
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Argentina
    Ratings:
    +0 / 0
    I have a big question about importing data from a PC based database (MS Access) to my Ipad.
    I want to manage data from students on my Institute (payments, exams, etc...).
    1 - wich software you recommend for creatin the data base on Windows PC
    2 - Is there any ipad app capable to import those data from that database via wifi connection.

    I was checking with Bento but I can´t really figure it out if it match my requirements.

    Hope you can help me:thumbs:
    Last edited: Jan 17, 2013
  2. hpulmer
    Offline

    hpulmer iPad Junkie

    Joined:
    Aug 30, 2011
    Messages:
    730
    Thanks Received:
    31
    Trophy Points:
    28
    Location:
    Germany
    Ratings:
    +31 / 0
    Take a look at this one....

    https://itunes.apple.com/de/app/access-mobile-database-client/id387300746?mt=8

    ☠ stay safe ☠ stay legal ☠
  3. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,282
    Thanks Received:
    1,990
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,231 / 1
    Bento is a pretty good database if you intend to either do all the work on the iPad, or get the Mac OS X version to sync with. The basic .csv import/export options are adequate for creating and/or backing up the essential text portion of the databases, but not for keeping records up to date on devices than can not be directly synced.

    If Windows and Access is your preferred desktop solutions, hpulmer's suggestion looks pretty good. There are both iPhone and iPad versions of the app. I don't know enough to offer better.

    If everything is up in the air, then you might also want to look at FileMaker Pro. This is the big brother of Bento. A very powerful solution that has both iPad and iPhone clients; able to either work offline and sync, or update the home database directly (when internet is available). Not cheap, but one of the top databases for small business and education.
    Last edited: Jan 17, 2013
  4. Sebita2305
    Offline

    Sebita2305 iPF Novice

    Joined:
    Jan 16, 2013
    Messages:
    13
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Argentina
    Ratings:
    +0 / 0
    Ok both answer helped me a lot. I think i have understud what bento is for and yes, is not the solution for me right now since i need continuos sync from the windows based computer (the one installed in the institute). Acceding to a mac here in argentina looks like an impossible thing for custom restriction. I am sure Fm pro is the solution but not affordable for me at this point. I think i will try the solution inthe first post to figure it out if it works.

    Thank so much for the help.
  5. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,282
    Thanks Received:
    1,990
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,231 / 1
    No problem. Please let us know how it works out.
  6. giradman
    Offline

    giradman iPad Guru

    Joined:
    Apr 26, 2011
    Messages:
    3,481
    Thanks Received:
    817
    Trophy Points:
    113
    Location:
    North Carolina
    Ratings:
    +880 / 0
    Hi Sebita - welcome to the forum! :)

    Not sure that I can add much to the already excellent recommendations, but I'm in the same situation, i.e. I have a half dozen personal databases in MS Access; also, I'm recently retired so no need for Access in my previous job (which I used for professional purposes); I need a new home computer and debating between a PC vs. a Mac - I don't plan to buy MS Office w/ Access if I get a PC (too expensive) and Filemaker Pro is also too expensive; I have Bento on my iPad but really is best w/ the program on a Mac for sync reasons, so not a solution for my purposes - this has really been a frustrating situation! So, just a brief outline of my potential solutions.

    NOW, what have I done; first, for my 'shorter' databases, I have used 'Numbers' on my iPad by exporting the Access DBs as either an Excel or *.csv file and importing into Numbers; for another, I have used 'Google Drive's online free spreadsheet (importing w/ *.csv option) - BUT, I have 2 CD Access files (classical & non-classical music) which print out to a total of 60 pages! My plan is to first update these on my home PC in Access (have a 10 y/o version) and then export then as Excel and as *.csv files - will then worry about where to place them (either Excel if I get another PC or Numbers if I buy a Mac).

    SO, bottom line, there is no easy answer or perfect solution to your situation; I'm not sure how large and complex your Access DB may be, but if BIG & complex, you will likely have more problems - even my larger Access databases are simple, so I'll get along, but can feel the pain for those w/ really big relational databases that will not be easily managed. Good luck and as others have said let us know if you find a solution - I'm still thinking! Dave
    • Like Like x 1
  7. Sebita2305
    Offline

    Sebita2305 iPF Novice

    Joined:
    Jan 16, 2013
    Messages:
    13
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Argentina
    Ratings:
    +0 / 0
    Thanks guys. I promise to update the post once y try some of the qnswers you post.
    Great forum by the way

Share This Page