Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Feb 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Remote updating of database using web interface

    I have been asked to provide a web interface in order that field engineers are able to update a database remotely.

    The data is currently being held in an Access 2007 database but a migration to MySQL will be considered.

    Whilst I am conversant with RDBMS, my knowledge of web technology is somewhat sparse.

    Is MySQL/PHP the best technology to implement this goal or is there a better alternative?

    TIA

  2. #2
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,397 Times in 1,220 Posts
    There are several options, PHP / MySQL being one.
    Personally I prefer ASP.NET. Without much experience, ASP.NET controls can spare you much of the tedious work that goes with implementing such a task.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2011
    Posts
    284
    Thanks
    33
    Thanked 2 Times in 2 Posts
    I have the same kind of problem, except that I capture my data in Excel at the moment. I just found a nice feature in Access 2007 that allows you to gather remote data using e-mail forms. The limitation is that the sender can update only one record at a time per e-mail (or maybe not??) the data is imported into the Access database table automatically when you receive your e-mails - pretty nifty.

    Consider that if you like?

  4. #4
    Star Lounger
    Join Date
    Feb 2011
    Location
    Brisbane, Queensland
    Posts
    53
    Thanks
    21
    Thanked 4 Times in 4 Posts
    Quote Originally Posted by ruirib View Post
    There are several options, PHP / MySQL being one.
    Personally I prefer ASP.NET. Without much experience, ASP.NET controls can spare you much of the tedious work that goes with implementing such a task.
    I would also use ASP.NET. One feature alone makes it worthwhile - when a webform goes out to the user, the user posts it back, and you return it with errors - ASP.NET keeps all the fields filled in for you. Whereas in PHP you need to re-fill each field on every round trip of the form.
    Beyond that, there are such beautiful features as the ComboBox DropDown List, which works really well.

    Visual Studio Express is free. I would use C# not VB because it's no harder and really a much better designed language, it really is the best computer language in the world.

    For a database, keep Access or consider Microsoft SQL Server, again the SQL Server Express is free.

    Hosting is well priced - have a look at RackServers and StudioCoast for ASP.NET hosting if you don't have your own Windows server on the net.
    Last edited by DavidPierson; 2011-02-25 at 20:02.

  5. #5
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,162
    Thanks
    47
    Thanked 976 Times in 906 Posts
    Any web form can be re-populated from the data entered. PHP doesn't do it automatically, it's up to you to code.

    cheers, Paul

Posting Permissions

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