Discussion Locked

Access data base through Web Site

0 helpful
12 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We have a Access data base and want to have users view/change/update the data through our web site via the internet. We currently access the internet through out LAN via a router and DSL using NAT. We have a server as one of the nodes on the LAN. Our web site (DNS)is hosted by a company called OWLS and our ISP is Frontline. How do I do this.

12 replies

by pierce9

I don't have an exact answer for you on this, and it may be hard to find a definitive answer if you asked many people. However you may want to look into ASP (Active Server Page) technology. This is a very light/fast technology for accessing databases from web pages without heavy java clients and the like. You may get other suggestions but I think ASP's are the way to go. Hopefully this will get you started.

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 donq

If you are using Access 2000 you are in luck. If not you may consider purchasing an update. 2000 creates ASPs (Active Server Pages) automatically under the "Pages" tab of the Database Window (new feature to Access 2000). You should also consider making a small copy of your .mdb file that includes only the portion needed for the web side of your firewall. From the reduced app you could then have Access automatically create your ASPs and then your only chore will be purging updated data via afunction that appends internet data to the company .mdb file and then deletes existing internet .mdb records so your maintenance is automated. Hope this helps. Don Quigg

by donq

You get better responces from folks when you rate their answers. If an answer helps, Approve; if not Disapprove so readers know where you are any what you tried.

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 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.

This discussion is closed to new replies.