Connecting Tech Pros Worldwide Forums | Help | Site Map

Data Access Pages

Newbie
 
Join Date: Sep 2007
Posts: 9
#1: Oct 4 '07
I am not a programmer, nor do I use MS Access with any frequency, so I'm not very confident in what I've been doing. I have read everything I can find about Data Access Pages and I've tried everything that relates. I have serveral DAP's for use on our company intranet. I can see the pages with no problem, but none of the data from the database is there. I've created connection files, connection strings, change the UseRemoteProvider to True, configured IIS server and the MDADC, created the DAPInternetAccount and I still can't see data. One of the pages is a directory. The datbase has three entries. If I look at the page from the host server, everything is fine. When I open from any other client the page is there, but no data. I've used several combinations of office products. The original was MS Access 2003 and FrontPage 2003. I couldn't get the pages to open. So I recreated the database in MS Access 2000 and FrontPage 2000 and FrontPage 2003. I got the pages but no data. I now have a database in MS Access 2002 FrontPage 2003 and FrontPage 2002. Does anyone have any other suggestoins.

nico5038's Avatar
Moderator
 
Join Date: Nov 2006
Location: The Netherlands
Posts: 2,232
#2: Oct 6 '07

re: Data Access Pages


I would advise you to drop your effort in using DAP's as Microsoft did drop the DAP's in Access 2007....
Best to use MS SQL 2005 or MySQL as database for your application directly from e.g. Frontpage.

Nic;o)
Newbie
 
Join Date: Sep 2007
Posts: 9
#3: Oct 9 '07

re: Data Access Pages


Thank you, sorry about the delayed response. I actually have the same database as a SQL database, but I'll need to see how to use it in FrontPage.
nico5038's Avatar
Moderator
 
Join Date: Nov 2006
Location: The Netherlands
Posts: 2,232
#4: Oct 9 '07

re: Data Access Pages


Perhaps this link (the database section) holds some interesting info:
http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx

Nic;o)
Newbie
 
Join Date: Sep 2007
Posts: 9
#5: Oct 30 '07

re: Data Access Pages


In case anyone else has this problem. It took a while,but I got the pages to work by creating another database (db1), imported the original database elements into the new database. When I modified the data access pages to create the links I linked to the original database. In Frontpage, I imported the database into my web, but not in the folder with my original database. My pages work now. And they can be updated from the webpage.
Reply