Data Access Page Problem

message from =?Utf-8?B?RGVsZiBNZWVr?= on 3 Jun 2004

hello all,

I'm new to Data Access Pages, and am trying to deploy a simple data access page on the internet.

I've followed the instructions in Microsoft's MSDN article "Deploying Data Access Pages on the Internet or Your Intranet".

I do not understand what I am doing wrong.

When I place the data access page in the C:\Inetpub\wwwroot, and try to browse the server name by typing http://servername/dataccesspage.htm, all i get is the header section of the Data Access Page, but no controls that allow a person to enter data. if I open the web page directly through windows explorer, it tells me "The UseRemoteProvider propery is supported only for pages saved to Web folders". So, I do believe I have the UseRemoteProvider property in the access database set properly.

It acts like the web page cannot connect to the database, which is also located on the webserver. Can anybody give me any pointers? I'm starting to get very frustrated with this. Do I need to install something else on my server?

Below is a copy of my MSDFMAP.ini file from my Windows 2000 Server.

;[connect name] will modify the connection if ADC.connect="name"
;[connect default] will modify the connection if name is not found
;[sql name] will modify the Sql if ADC.sql="name(args)"
;[sql default] will modify the Sql if name is not found
;Override strings: Connect, UserId, Password, Sql.
;Only the Sql strings support parameters using "?"
;The override strings must not equal "" or they are ignored
;A Sql entry must exist in each sql section or the section is ignored
;An Access entry must exist in each connect section or the section is ignored
;Access=NoAccess
;Access=ReadOnly
;Access=ReadWrite
;[userlist name] allows specific users to have special access
;The Access is computed as follows:
; (1) First take the access of the connect section.
; (2) If a user entry is found, it will override.

[connect default]
;If we want to disable unknown connect values, we set Access to NoAccess
Access=ReadWrite

[connect C:\database\db1.mdb]
;If we want to disable unknown connect values, we set Access to NoAccess
Access=ReadWrite

[sql default]
;If we want to disable unknown sql values, we set Sql to an invalid query.
;Sql=" "

[connect CustomerDatabase]
Access=ReadWrite
Connect="DSN=AdvWorks"

[sql CustomerById]
Sql="SELECT * FROM Customers WHERE CustomerID = ?"

[connect AuthorDatabase]
Access=ReadOnly
Connect="DSN=MyLibraryInfo;UID=MyUserID;PWD=MyPassword"

[userlist AuthorDatabase]
Administrator=ReadWrite

[sql AuthorById]
Sql="SELECT * FROM Authors WHERE au_id = ?"

Thanks,

Delf

Doug Munich replied to =?Utf-8?B?RGVsZiBNZWVr?= on 5 Jun 2004

I think that when you access Data Access Pages with your web browser you
don't do it through HTTP, you do it directly. So in your web browser
address bar you put something like
\\Servername\SharedFolder\dataaccesspage.htm

"Delf Meek" <delfmeek@yahoo.com> wrote in message
news:5DB9A4D1-C4BE-4FBF-A1B5-CC1CA52D0EE4@microsoft.com...
page on the internet.
Access Pages on the Internet or Your Intranet".
browse the server name by typing http://servername/dataccesspage.htm, all i
get is the header section of the Data Access Page, but no controls that
allow a person to enter data. if I open the web page directly through
windows explorer, it tells me "The UseRemoteProvider propery is supported
only for pages saved to Web folders". So, I do believe I have the
UseRemoteProvider property in the access database set properly.
located on the webserver. Can anybody give me any pointers? I'm starting
to get very frustrated with this. Do I need to install something else on my
server?

Archived message: Data Access Page Problem (Microsoft Access)