Results 1 to 13 of 13
  1. #1
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271

    Unanswered: Access on the internet

    Is there code, or a way, I can enter a form on the internet and have the data sent to my database at work?

    I have a Microsoft Access Database that we use. I would love for someone be able to enter data, click a button and all the data would go to our Database.

    Sometimes the computer with file may be closed. If that's the case maybe, have the database file online? Or have it hold the data online, then have a button to retrieve the data when the computer get's turned on.

    Please go easy on me. I am very green when it comes to working with Access and coding.
    Any ideas are greatly appreciated.

    Michael
    Gotta to do some code

  2. #2
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271
    Any ideas on
    Gotta to do some code

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    There is no easy way to do it.
    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
    well you could write a web page that directly enters data into an Access (well strictly speaking a JET) datastore. lots of web technologies can do that.. including ASP, PHP and so on... arguably you could fire up an Access app or bit of VB/vbscript as a CGI process and do the dirty deed there.

    you could get the information sent to a specific email account (or some other mechanism to make it indentifiable), and periodically use Access to talk to the email client that has that email on it, read through the email and strip out what data is required. I used that technique for a number of years on a low budget web system. Effectively the email was downloaded in Outlook, an access process was written using OLE automation to read emails, strip out what was relevant, delete to avoid duplicates

    As StarTreker says neither way is especially easy

    BUT

    if you don't try then you don't learn.....

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    To be able to add data to the database; it must be "contactable" i.e. must be online. Therefore when the PC is turned off; you can't add or retrieve monkeys!

    If you're determined to use access I suggest you build the web front end in ASP (more similarities between the languages used) and have the database hosted online.

    Note that Access only allows at a MAXIMUM 25 concurrent users. And you will only ever reach that value on a day that doesn't have a "y" in it.
    George
    Home | Blog

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Using healdem's example, the PC can be off... the e-mail will eventually arrive and the Access process will then do it's work to pull the data out of it.

    It's better to use the page to store the data in a MySQL server / SQL Server and then use a database on the PC that simply uses that server as its data source.

    Cleaner. But it's still not "easy".
    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

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    The email route has its attractions for a small scale technological newbie
    it doesn't require any substantial knowledge, beyond the ability to send an email from the webserver, it requires minimum changes to an existing system.

    getting access to talk to Outlook is pretty straightforward. Its all stuff that is relatively small scale, proven and workable. it isn't an immediate solution (ie change in website triggers change in data, but if thats not required then its workable, reading the OP suggests that this is a 'would be nice to have' feature, rather than must have, so Im guessing its more to save the OP time rather than data cirticality is the driving factor.

    It doesn't require learning any new SQL, it doens't require interfacing Access with that other SQL engine. It may require a bit of server side scripting to send the email, you may be ablke to send sufficent for the purposes in an email header straight from the page obiviating the need for server side scripting.

    Yes the ideal would be an integrated system, updating data immediately, and all the other bells and whistles we as data professionals would want to implement, but sometimes the lump hammer is the best tool in the box

  8. #8
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271
    OK with much of this, I can see it is way above my head. You are right If i don't Try, I'll never, learn...

    Not sure who mentioned this (if anyone), but maybe I can put the file on the server if need be.
    I have no problem keeping the computer on all the time. How would it then be accessed from the Net?

    We are a very, very small company, about 8 people. About 4 of which need to access this file. I am the administrator. We don't have money to pour into this.

    Not real sure what some of the things you are mentioning: mySQL, ASP, Jet, etc.


    That being said. I appreciate your feedback and advices. I will do searches on some of these things.

    Thank You guys, keep the ideas coming! i love this site!
    Michael
    Gotta to do some code

  9. #9
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    The more you outline your requirements and experience the more Id suggest going down the email route. The on line web route may be a learning hurdle too much for you right now.. thats not to say you shouldn't couldn't musn't go down that route, I just suspect it may be a technology to many to learn right now.

    JET is the data engine that Access uses as its default method of storing data. If you use an access application that is retrieving data then you are using JET to store that data, unless you are using a server back end.. and I'm guessing, pretty certain you wont be using a server.

  10. #10
    Join Date
    Feb 2006
    Posts
    26
    Quote Originally Posted by surfacesys
    Is there code, or a way, I can enter a form on the internet and have the data sent to my database at work? I have a Microsoft Access Database that we use.
    Michael
    Setup ODBC for your Access Database, be sure to setup username and password for it. Then use PHP script on your webpage for the form to access the ODBC. That how I did on our billing and time clock Access Database.

  11. #11
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271
    That sound's awesome!
    I just wish I knew what some of these things are??
    What is ODBC?
    What is PHP script?

    If you can slowly guide me in the right direction, maybe I can do just what you are suggesting.

    Keep in mind I am our IT Administrator . And not a very good one at that.

    Michael
    Gotta to do some code

  12. #12
    Join Date
    Feb 2006
    Posts
    26
    It would be a long instruction for me to write, so I went to search on Google (your best friend, that's how I found this forum), and found a similar instruction that may help you:

    hxxp://xxx.phpfreaks.com/tutorials/61/0.php

  13. #13
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Quote Originally Posted by itchibahn
    Setup ODBC for your Access Database, be sure to setup username and password for it. Then use PHP script on your webpage for the form to access the ODBC. That how I did on our billing and time clock Access Database.
    Isn't that exactly what I said?? lol
    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
  •