Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2008
    Posts
    2

    Suggestions for MS Access Web-based Replacement.

    Our company is currently using Access 2003 to connect over ODBC to a MySQL database. We chose Access 2003 because of its use of forms. More recently, we have been looking for a solution which might centralize our process.

    Instead of having to maintain 5 workstations with Access installed, we’d like to move to a web based system. Does anyone have any ideas for an Access replacement which uses a similar interface on a centralized server? Thanks!

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Well, I haven't used it much, but open office base has some of Access' features. And, you can link base to a database server back end.

    However, if you're setting up a web-based system, use mysql or postgresql as the database server, use their GUI as the front end, and connect to the database server with php or asp to serve the data to the clients.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    I dont understand the point/problem over 'having to maintain 5 workstations"..
    but fwiw
    if you want to go down the web approach then somehting like PHP or PHP/Javascript (AKA AJAX) will get you there.

    however one thing to bear in mind is that standard Access isnt' very secure, designing web applications (unless you are very switched on) can create massive security problems. OK accepting that you are running your app over an intranet or VPN then you may be less prone to such problems, but they still exist.. tying down a web based app is doable, but it takes a lot of thought.
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Have you considered Citrix?
    Requires no re-write, since you can just use your existing Access database (FE and BE) on the hosted platform.
    George
    Home | Blog

  5. #5
    Join Date
    Feb 2007
    Posts
    33

    Web based data access / entry

    I've used Microsoft SQL 2005 Express edition for smaller applications like this. MS Visual Developer 2008 and MS Visual Web Developer make it pretty easy to make data entry forms. I already had a running exchange server that was running Internet Information Services (Microsoft Web Server). It makes it pretty easy to turn on web security and force users to authenticate and log in to use the form. I also caputure their user name and write it to the database when they make an entry.

    If you need help or want someone to take a look at what you have to offer a more informed answer I'd be happy to. I do consulting work regularly. Message me if interested.

Posting Permissions

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