+ Post New Thread
Results 1 to 6 of 6
Web Development Thread, Accessing Access from the Internet in Coding and Web Development; Hey guys, I need a bit of help ... a lot of help really lol. I'm trying to access an ...
  1. #1

    Join Date
    Jan 2008
    Location
    UK, West Mids
    Posts
    15
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Accessing Access from the Internet

    Hey guys,

    I need a bit of help ... a lot of help really lol.

    I'm trying to access an Access Database from the Internet. I want to be able to edit/update and delete information in it.

    The whole things leading to the creation of a 'Ticketing System' for my schools IT services.

    And I know some of you may say to just buy one but I'd rather learn how to create one for myself.

    Any useful links or words of wisdom?

  2. #2

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    6,069
    Thank Post
    902
    Thanked 1,013 Times in 825 Posts
    Blog Entries
    9
    Rep Power
    350
    If your creating something from scratch, is there a particular reason for using access? Usually MySQL/HTML would be considered a better solution If it's to be accessed from the Internet. AFAIK Access DB's doesn't run as a server so you'd be basically downloading the DB file locally and running it, then uploading it again. Not sure this is what you'd want. Also, Access DB run from a network share across the internet would be very very slow.

  3. #3

    Join Date
    Jan 2008
    Location
    UK, West Mids
    Posts
    15
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by tmcd35 View Post
    If your creating something from scratch, is there a particular reason for using access? Usually MySQL/HTML would be considered a better solution If it's to be accessed from the Internet. AFAIK Access DB's doesn't run as a server so you'd be basically downloading the DB file locally and running it, then uploading it again. Not sure this is what you'd want. Also, Access DB run from a network share across the internet would be very very slow.
    Thanks for the reply!

    I've read that Access DB's are terrible online. But my MySQL skills are pretty lacking.

    Do you think it'd be easier doing it with MySQL?

    Any links to point me in right direction?

  4. #4

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,271
    Thank Post
    884
    Thanked 2,749 Times in 2,322 Posts
    Blog Entries
    11
    Rep Power
    785
    If you want to use the access front end and a propper DB back end look at using MS SQL express 2005. It is free and you can create your database through access by telling access to create the new DB in the server.

    This means that you can use an access front end to start with (ADP file) which still keeps the data on the server for speed. You can also tie this data into an HTML application at a later date with the same ease as a MySQL DB.

  5. #5

    Join Date
    Jan 2008
    Location
    UK, West Mids
    Posts
    15
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by SYNACK View Post
    If you want to use the access front end and a propper DB back end look at using MS SQL express 2005. It is free and you can create your database through access by telling access to create the new DB in the server.

    This means that you can use an access front end to start with (ADP file) which still keeps the data on the server for speed. You can also tie this data into an HTML application at a later date with the same ease as a MySQL DB.
    I understand what you mean but I dont know how to do it.

    And I'd definately only want an HTML application to interface with the database.

    Are there any tutorials out there?

  6. #6

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,271
    Thank Post
    884
    Thanked 2,749 Times in 2,322 Posts
    Blog Entries
    11
    Rep Power
    785
    You may be better going on to somewhere like sourceforge and downloading a free open source one. There are loads of them out there.

    If you really want to build your own there are lots of languages that you can use, if you download the express version of Visual Web Developer it would be pretty easy to throw something together. This site may help:
    Learn : The Official Microsoft ASP.NET Site

    You could also use any of the open source technologies which also have tutorials scattered around.



SHARE:
+ Post New Thread

Similar Threads

  1. Restricting Internet Access..? How
    By Grommit in forum Windows
    Replies: 24
    Last Post: 21st April 2008, 02:30 PM
  2. Cannot access Internet after rebuild
    By Zoom7000 in forum Windows
    Replies: 5
    Last Post: 8th April 2008, 08:05 PM
  3. Blocking Internet Access
    By jcollings in forum How do you do....it?
    Replies: 29
    Last Post: 24th January 2008, 10:24 AM
  4. disabling Internet Access help!
    By Gardinho in forum Windows
    Replies: 3
    Last Post: 5th July 2007, 03:17 PM
  5. Internet Access Captchas
    By pete in forum Jokes/Interweb Things
    Replies: 0
    Last Post: 5th April 2007, 08:02 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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