Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2008
    Posts
    1

    Red face Unanswered: Input needed for newbie *blushing*

    OK, I will admit upfront that I am no wizard here. My company uses access and I understand how to create new databases and manipulate, etc., data that we already have... but I find access to be rather tedious and tricky and I'm looking to create a database with a web interface so that our feild employees can enter information that will be stored in a central location via the web.
    Access 2007 apparently doesn't support the data pages function the earlier versions had. So, since I'm basically starting from scratch, what would you suggest as the easiest, most user friendly,database design program I could buy and use?
    Any input would be appreciated - I'm looking at File Maker Pro right now...!

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    File Maker Pro? I had to deal with a Macintosh version of File Maker Pro (converting it to Access) and didn't really like File Maker Pro (Macintosh version). But I can't offer you any suggestions for web other than using ASP or the new and "greatest" .NET. I can't say how easy .NET would be but I had good luck with ASP.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I've never been impressed with ANY version of FMP. Users tend to like it though because it's simple to use -- like a MSWorks database.

    For online databases I tend to only recommend MySQL / SQL Server backend with either PHP or ASP as a front end. But that is far from "simple".
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    data access pages are history.. it was always a farily clunky way of deploying access on an intranet/internet.

    you can get the same effect by downlaoding Access runtime and deploying MDE's a compiled form of Access files.

    if your users are connecting over a VPN (or its a closed userbase) then an Access MDE running on runtime may be a way to go.. if you want to deploy the db outside the intranet (to an open userbase[ie you dont know what the users have]), then you are probably better off deploying it as an ASP or other web scripting technology.

    personally If you can I'd go scripting with a webserver.. but although I don't regard it as difficult. non simple as StarTrekker seems to, it does take some time to pick up the new pieces.. on eproblem with PHP, in much the same way as VBA its possible to write really crappy but functional code very quickly. code that can be a nightmare to maintain over time.. it does require more design more thought to get the best out of.. I've heard simialr commnets about ASP but its years since the last time I looked at ASP.

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    It may not be difficult but it is far from simple -- I mean it's not like you can click a table and then click on a form wizard button! THAT's simple!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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