12 replies
by pierce9
by jschaiman
by hdahl
You do not say where you are keeping your Access DB. You'll run into a lot of trouble if it is in your LAN. Security, a local web site, local firewall, proxy etc.
The DB should be hosted with your web site.
ASP is an easy way of connecting to aDB.
You have to check if your ISP supports ASP.
You should check the price as well. It is typically more expensive to have an ISP host a site with a lot of technologies.
Good luck.
by jschaiman
by donq
by indotech
This is very simple using ASP and ADO
All you have to do is find out from your web hosting company what is the DSN(data source Name) for your database(.mdb file). Use the following code snippet. Modify according to your needs
<%
Dim rslist
dim conn
dim strSQL
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DSN=your dsn;UID=youruid;PWD=yourpass"
strSQL = "SELECT UPDATE INSERT etc."
set rsList = conn.Execute(strSQL)%>
by jschaiman
by support
The Book Active Server Pages for Dummies has some excellent full examples of maintaining an access data base. The examples are not snippets of code. They are complete working applications and they are on the CD. When you are ready, I recommend the book Instant ASP Scripts, which also contains dozens of examples and each example is fully explained with a detailed how and why of each line of code.
The best ASP code generator on the market is Macromedia's Ultradev.
by jschaiman
by jschaiman
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending