Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 9 of 9
  1. #1
    New Coder
    Join Date
    Apr 2004
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need to migrate MS Access 2002 db to Pocket IE on Win Ce 2.11 H/PC

    I need to migrate the database I created with Microsoft Access 2002 on Windows XP to NEC Mobilepro 780, with specs as follows: Pocket Internet Explorer (same as IE 3.0). Javascript, JScript, and HTML 3.2 compatible. No support for VbScript, CSS, DHTML, or frames. Screen dimensions are 640 pixels wide by 214 pixels tall. The OS of the handheld device (H/PC) is Windows Ce 2.11. The system architecture is MIPS 4121.

    The Access 2002 database prototype is fully functional and ready to email to you as a zip file. It has 14 fully normalized (optimized) tables, only 4 of which have relationships between them. It has 2 forms, with text boxes as the only controls except for 2 combo boxes and (many) labels. Each of the 2 forms have multiple pages (tabs).

    I want to migrate the database, including the forms, their controls, the tables, and the (in-process) HTML help system to the H/PC by utilizing Javascript arrays and web-based forms and controls.

    Please help. I'm an individual (not a company) going on a church missions trip this summer, so I need this ASAP!

    Thanks,
    -Dave

  • #2
    Senior Coder
    Join Date
    Feb 2004
    Posts
    1,206
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You say your NEC Mobilepro 780 supports Pocket Internet Explorer (same as IE 3.0). Javascript, JScript, and HTML 3.2 compatible. That's fine for creating your forms, but how do you plan to stick a database in there?

    And how do you plan to link the html to the database? Not possible. You'd need a server-side language to interact with a database.

    There's not Pocket Access? or some other database program on there?

    Good luck,
    Sadiq.

  • #3
    Senior Coder
    Join Date
    Feb 2004
    Posts
    1,206
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I was just doing a little reading on your machine, and I'm pretty sure I read Pocket Access.. but I think that was for the 880... maybe you need an upgrade? lol

    But I wonder if you can't buy Pocket Access and install it somehow.. I don't know much about your type of machine, it almost looks like a laptop but..

    Sadiq.

  • #4
    New Coder
    Join Date
    Apr 2004
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Arrays

    Thanks for your reply. I've read that Javascript does database tables in the form of arrays. That's what I want to do, use arrays.

    The Mobilepro 780 does have Pocket Access.

    Please let me email you the zipped up Access database. Tell me what you think you could help me with to migrate it to IE 3.0/Javascript.

    Thanks again,
    -Dave

  • #5
    Senior Coder
    Join Date
    Feb 2004
    Posts
    1,206
    Thanks
    0
    Thanked 0 Times in 0 Posts
    So why don't you just migrate your current Access project to Pocket Access?

    I don't really want to get that zip file emailed to me... I don't want to look at it if I don't need to.

    Sadiq.

  • #6
    Senior Coder
    Join Date
    Feb 2004
    Posts
    1,206
    Thanks
    0
    Thanked 0 Times in 0 Posts
    It's easier to work with a database than trying to mimic a database using arrays.

    Also will you be adding, removing, or changing values in the database? In that case you actually have to have the database values stored in a text file, have the Javascript load up the text file into memory, and parse the file into the arrays accordingly. Then when you make changes to any records, you have save these changes to the text file.

    It's not going to be an easy task... I would do my best to migrate the existing Access project to Pocket Access if I were you.

    Good luck,
    Sadiq.

  • #7
    New Coder
    Join Date
    Apr 2004
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    If only

    Pocket Access is absurdly limited. It doesn't support forms and has a limit of 76,000 records.

    I realize that getting there may not be so straightforward, but once "there" with a Javascript/Pocket IE solution, I'll have a reliable, non-proprietary solution with a small footprint and unlimited scalability.

    If you know how to code in Javascript, please make me an reasonable offer! This need is not going away!

    Thanks,
    -Dave

  • #8
    Senior Coder
    Join Date
    Feb 2004
    Posts
    1,206
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You're going to pay someone to make this for you? Hmm.. what sort of deadline are you looking at?

    I think it is doable, but it'll be ugly and not necessarily very fast. Also, because you've got IE3, that's probably going to impose a few restrictions with the Javascript capabilities (although don't quote me there!).

    Have you considered purchasing a laptop? That way you're not restricted at all!

    I think you should post this in the Work offers forum. I'm not personally interested as I have a programming position, and I'm not one to code outside of the 9am-5pm time zone.

    Good luck,
    Sadiq.

  • #9
    New Coder
    Join Date
    Apr 2004
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •