Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can not open or link to database on web server (Access 2003)

    I created a form in Front Page that, when you click Submit, dumps the results into a DB within the site. The site is published to a hosted web server that is offsite, but that I have the admin credentials for. I'm a little green when it comes to this, so someone let me know if I'm trying the impossible.

    I'd like to be able to view the Results table, but am unable to. I go to File | Open in Access on my machine, then type the URL (path) of the remote database in the file name field and when I click Open it tells me that Access is unable to open the data access page. It then goes on to tell me I'm trying to open a database off of a web server. Duh. So....is it not possible to do so? How else am I supposed to view the results in the database short of FTPing to my desktop, which seems like a pain.

    Ultimately I'd like to be able to link a local front end on my computer to the results table "back end" on the web server. I have tried this already, by opening a blank database, then going to File | Get External Data | Link Tables, typing in the URL, but when I click okay I get an error "Not a valid file name." I realize that I don't know enough about this, and am probably missing a key step. Can anyone shed any light for me.

    Thanks - Sat.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can not open or link to database on web server (Access 2003)

    I think you'd have to be able to connect directly to the server, for example through a VPN, but I don't know if the hosting company will allow that. Otherwise, you'd have to transfer the database using FTP.

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can not open or link to database on web server (Access 2003)

    I know how to do the later, although I may have bigger problems. Copied the .mdb file from the site to my local machine and opened it up and there is nothing there - no results. And I've been entering/submitting bogus data just to make sure that it could accept data. I'm not sure what's happening there - I can enter info into the form, then when I hit Submit I get a nice summary/confirmation page with all the data I just typed. But.....apparently none of it is making it to the DB on the server. Any ideas?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can not open or link to database on web server (Access 2003)

    That is probably a question for the Web Design, Coding and Scripting forum. The Loungers providing assistance in that forum would need to have information about the code you are using.

Posting Permissions

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