Click here to Skip to main content
15,867,568 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I've been handed responsibility of updating/upgrading a non-profit's website where html reads/writes to an Access database via ASP. I'm on Windows 10 Pro 19043.1766. Have Visual Studio Code and XAMPP loaded. I want to test my html code changes locally on a locally stored Access file. Can it be done or should I be thinking of R/W'ing to MySQL? Background: Fortran programmer, classes in html, css, & Access.

What I have tried:

I have searched on variations of "html write Access localhost". Indirect indications of needing to R/W to MySQL via XAMPP. Prefer to stay with Access for a while longer.
Posted
Updated 9-Jul-22 13:51pm
Comments
Member 15627495 10-Jul-22 1:20am    
as Html only structure web page, it's not the html which read the db.

you need Php ( or Vbscript / WSH script )
Php can read Access DB with a connection string to the Db, with a light weight script.
www.php.net
Member 15104477 10-Jul-22 14:37pm    
I should have mentioned that I do have an ASP connection string and it works on the ISP's site. But it takes so long to make a correction, upload it and then test it out. I was looking for a way to do code changes and testing locally. It should be faster. I know **of** PHP workbench with respect to MySQL but I know ASP and Access better. Is there a way to test html, asp, and access locally with a Win 10 Pro system? I assume there is but what I find on the internet tends to be dated or cryptic on how to use it.
Richard Deeming 12-Jul-22 4:07am    
You can install IIS on Windows 10 Pro:
Install and Setup a Website in IIS on Windows 10[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900