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

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

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?

Reply | Quote

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.

Reply | Quote