I've created an Access 2002 database with two Data Access pages. I uploaded them to my website hosted by another company. When I access one of the Data Access Pages I get two measeges saying, "Data provider could not be initialized.", and, "Not a valid file name."
I know that's because it cannot locate the Access database, but I don't know how to fix it. I don't have control over the web server. Is there any way that I can post a Data Access page without needing the help of the hosting company to make special arrangements because they will charge extra?
That's just the limited nature of data access pages that the user's computer needs to be able to establish a client-side connection to the database. That's why data access pages aren't really used much on the Internet.
And for your info here is my take on putting a database on the Web WITHOUT requiring the user to have a copy of the database on his or her PC.
You and others can have access to a database hosted on the Web from any location that has a browser with an Internet connection.
The Web database concept makes sense if you and your people want to do work in various locations in or outside the office and still be "plugged" in.
For example you could have employees enter timesheets or have sales reps log their contacts. Or perhaps you'd like customers to be able to check the status of their orders online without having to call the company.
If you want a Web database, typically what would happen is that a database such as Access or MySQL (basically just consisting of tables) would be put on the Web.
Dynamic Web pages are similar in many ways to regular HTML pages. But they are "live" because the user can read from and write to information in the database. An example where you can login and add, edit, or view fictional customers and invoices is at http://www.bullschmidt.com/login.asp
Not all Web hosts will handle dynamic Web pages but many do. The Web hosts that can handle ASP pages usually have a Windows 2000 operating system running an IIS Web server.
And the following newsgroup is good:
Or for a "quick and dirty" generic ASP open source solution to putting databases on the Web that just requires setting up a configuration page for each table or query and uploading the database to the Web as long as there is an autonumber field in each table (and you'll probably also separately want to create login capabilities), perhaps try something like this:
GenericDB by Eli Robillard http://www.genericdb.com and then click on the Tips link to see an example