Access2000 Data Access Pages

A beginner as far as databases are concerned but have put together a db and using a data access page to read and alter records with pulldown menus etc.

It works great on my hard drive but when I upload it to my web space the data access page continues to makes changes to the database on my hard drive. In addition the data access page can be seen from other machines on the web but is not fully functional.

My web server has IIS, if this helps.

I simply want others to see the Data Access page on the web and the changes be made to the database on the web server.

I've been at this one for week, it's driving me crazy!

The data access pages are hardcoded to look at the machine were they were created. You will have to change the links once you have uploaded the database and forms.

Thanks Victor, I'm a real beginner in this subject. I've have found a way to alter the link in the in the htm of the DAP but still no luck and have also changed the 'use remote provider' to 'true' in the properties.

Any chance you could give me the idiots guide to link the two together?


Thanks
Tom

The access database resides on the webserver? Do the forms reside on the webser as well? How are the users accessing the forms? Does each person have MS Access installed and the forms are downloaded or is this through a web applicaiton.

Victor,
The access database and the DAP reside on the webserver.
the plan was to have all 5 users view and ammend the DAP via the net from pc's which are Win 2k but not all will have access installed.

Tom

Question: How did you plan on having those PCs interact with the MS Access database? Web Application or through the MS Access forms?

Victor,

I had hoped that the Data Access page facility in access2000 would enable me to make the data access page available on the web by making the web address available to the users. The DAP would then interact with the database on the same. Microsoft have some information on the subject but I found it a bit over my head. The information can be found on:
http://msdn.microsoft.com/library/d...l/deploydap.asp

First do your clients have the stated requirements necessary for viewing the pages? I am assuming you will be using a three tier architecture, clients - web server - database.
Will your clients authenticate, edit and review data on the webserver then the webserver will be communicating with the database?

The short answer is to all questions.

I have a database, db.mdb. I have a data access page, dap.htm.

I originally had these saved to a network fileshare, p:\sales\online. dap.htm functioned properly when connected using either the file path (p:\sales\online\db.mdb) or the UNC (\\server\volume\datashare\data\sales\online)

I want the dap.htm to be available over the Internet. So, I copied the page and database to my web server (c:\inetpub\website). Now I need to point the dap.htm that exists on the web server to the db.mdb that also exists on the web server.

I tried using \\webserver\c$\inetpub\website\db.mdb. When I enter URL the page comes up blank except for the page title. When I enter \\webserver\c$\inetpub\website\dap.htm the page functions.

I tried using c:\inetpub\website\dap.mdb. When I enter URL the drop down boxes are empty and my text boxes are populated with #Name? When I enter \\webserver\c$\inetpub\website\dap.htm the page still does not function. I configured the dap.htm to use RDS with no change

I have been working on this for two days. Input is greatly appreciated. I'd like to get it working and then will worry about implementing a touch of security.

I have been working on this problem for two months now....did you ever get it to work? If so, I would appreciate any tips? Thanks

I got my dap to function. It had nothing to do with the link to the database. I continued to use the UNC to the database on the web server. The key was adjusting my browser's security settings. My browser seems to feel that this two tier architecture is causing cross domain access. So I went into Tools - Internet Options - Security - Internet - Custom Levels and set the Access data sources across domains to prompt. Whalaaa.

Is that the only setting you had to change? My level is already set to prompt for that setting?

Thanks for the reply!

I've ran into the same scenario with the cross domain and security issue. If I lower my security level, it works great. However, I'm not wanting everyone who uses the page to have to lower their security level on the browser (it doesn't work at the medium status).

Do any of you have any suggestions as to tell internet explorer that it is safe to run?

try adding the server to the "trusted sites" of the clients. may work. good luck!