How to connect php file to ms access?

Publishing An Access Database On Internet

• I am interested in creating a database using MS Access 2002 with the objective of creating web pages for data entry, generate reports to view the live data and publish on the IIS server so as to be accessed over Internet. I have used Data Access Pages to do Data Entry, which writes to a database. Whenever we are accessing the Data Entry pages over Internet we receive a Blank Message Box as error. However this works fine on Intranet(LAN ) but not on the Internet . Would like to know how to connect to a remote database over Internet using the Data Access Pages. Have attempted the following but have not been successful : 1. In the data Pages Properties we have set the "UseRemoteProvider = True" 2. On the IIS Server Granted Access to RDS -Based pages and Applications under Directory Security\IP Address and Domain Name Restrictions\Edit\IP Address and Domain Name Restrictions\Granted Access 3. Have executed the C:\Program Files\Common Files\System\msadc\handsafe.reg registry file and added the [connect C:\inetpub\wwwroot\Data\MyDB.mdb] Access=ReadWrite to the MSDFMAP.ini file .

• Answer:

  Hi marrett88-ga, For deploying Data Access pages over the Internet, you have to configure your setting to support 3 tier data access. Also, a lot of configuration has to be done on the webserver on which the pages and the database reside. The following MS KnowledgeBase Article provides step by step instructions on how you can do this : - Article 291783: How to Deploy Data Access Pages over the Internet ( http://support.microsoft.com/default.aspx?scid=KB;en-us;q291783 ) You can find a comprehensive instructions and an in-depth discussion on this topic in the following (40 page!) MSDN Library Article : - MSDN Library: Deploying Data Access Pages on the Internet or Your Intranet by Mark Roberts ( http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/deploydap.asp ) This article is a must read for anyone thinking of deploying DAPs over the Internet. ================================================== In your case, I recommend that you reconfigure your setting following the step by step guidelines provided in the MS KnowledgeBase Article(linked above). From the information you have provided, it appears that you have setup the Remote Data Services(RDS) correctly. However, you make no references to whether you have configured Folder and File permissions and Anonymous Access on the webserver or not. Please configure your settings as per the MSKB article and tell me if it works or not. Another thing you need to be aware of, are the software requirements for the computer on which you want to view these Data Access Pages. The client machine needs to have the following installed : - Microsoft Internet Explorer 5 or later - Microsoft Office Web Components (for pages created with Access 2000) - Microsoft Office XP Web Components (for pages created with Access 2002). To find out more about them, check out the following MSKB Article : - Article 288729: General Information About Licensing and Using Office XP Web Components ( http://support.microsoft.com/default.aspx?scid=kb;EN-US;288729 ) Also make sure that your webserver( which hosts the DAP pages) and your database server(which hosts the database) meet the following requirements : Web Server Requirements: - Microsoft Internet Information Server 4.0 or later - Microsoft Data Access Components (MDAC) 2.1 or later (for pages created with Access 2000) - Microsoft Data Access Components (MDAC) 2.5 or later (for pages created with Access 2002) Database Server Requirements: - Microsoft Jet Database Engine 4.0—for pages that use three-tier data access to work with data stored in an Access back-end database (.mdb). - Microsoft SQL Server 6.5 or later—for pages that use data stored in a SQL Server backend database. For more information on the above requirements, I highly recommend that you check out the MSDN Library Article linked above. ================================================= Hope this helps. If you need any clarifications, just ask! Regards, Theta-ga ================================================= Google/Google Groups Search Terms Used : "data access pages" error blank fields over the internet "Data Access Pages" blank message box error internet "Data Access Pages" work on Intranet update remote database over internet