Data Access Pages

[md9108]

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]

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)

[md9108]

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]

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

Nic;o)

[md9108]

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.