Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2008
    Posts
    12

    Unanswered: Can I Create A Webpage That Will Collect Data For My Db In Access?

    Ok here is what I'm Trying to do...

    I have a Database that I use at Work to Collect All Leads that we start working. I dont need them updated, its simply a report that shows opportunity to do business. Right now I have an E-mail form that my guys fill out and E-mail me back. Then access imports the data. I would like to build a very simple webpage that will have a form that E-mails me the info in a way that it goes straight into access. Can someone help me?

    Thanks so Much!

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Maybe you should ask this in the PHP forum or something... you're asking for help to build a web-page in an Access forum?

    I'd build the page in PHP to write to a MySQL database and then have your Access database import the data from the MySQL table(s).
    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

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    lets take a step back
    why would you need to, what is the problem with the current approach
    could you solve that problem without tinkering with an existing workign system, and if so what are he costs of the various approaches.

    ferinstance
    whats to stop the access email read from copying you in on the email, or move the email to another directory/folder in you email clienet after its read the data, or you looking into the email account where the data is going. or getting 'your guys' to send a copy email direct to you (possibly from your form.

    its perfcetly possible to get a webpage to talk directly to a database, whether you would choose JET for that I dunno.. I tend to work almost exclusively on server websites rather than JET websites. .but it should work providing the number of people accessing the database concurrently sn't too high.

    but as StarTrekker says you need to do some server side scripting. you may get away with a standard HTML form to collect the data, but you will definitely need something on the server to interpret the user responses and stuff the data into your target db. if you want to develop a web apop go for it.. but be prepared for a learning curve... thatss why I'd suggest you 'tinker' with your current app process to give you want you want rather than start a new system
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Dec 2008
    Posts
    10
    Quote Originally Posted by koster88
    I would like to build a very simple webpage that will have a form that E-mails me the info in a way that it goes straight into access. Can someone help me?

    Thanks so Much!
    I think that you should check the WhizBase - it could be a solution for your needs.
    The URL is http://www.whizbase.com
    Take a look, there is even an example that adds records to Access database (it does not send e-mail, but WhizBase can do that too).

    Hope this helps,
    Faik

Posting Permissions

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