Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
browser connect to Access without IIS 2
- Thread starter alfordjj
- Start date
-
1
- #2
- Thread starter
- #3
Thanks for your reply, jedraw.
I have only tried what I know: PHP & VBScript. Both of these require a web server on the box to connect to the DB. I read up on JS, but it looks like it requires one as well. I will look at the TransferText Method and see if it will work for me.
Further info:
I have inherited an MDB that has a clunky interface and I want to give it a smoother, HTML based, one. This database will be distributed to many locations and there is no central web server upon which to place it. Only the initial data is important to distribute, not any additional data that users my add; so I'm not worried about maintaining the data. It's simply giving sites info for them to start with. Having every site install IIS (or some other web service) would cause more problems than it would fix.
Here is an example:
An MS Access database located at c:\MyProgram\MyDatabase.mdb. Several HTML pages located in the same dir. Shortcut to index.html on the desktop.
When index.html is launched it pulls info from a table in MyDatabase.mdb and displays it. The user then can make changes to the data, click the submit button and MyDatabase.mdb would be update with the changes.
All the files local on the machine.
I hope this clarifies.
Thanks again.
I have only tried what I know: PHP & VBScript. Both of these require a web server on the box to connect to the DB. I read up on JS, but it looks like it requires one as well. I will look at the TransferText Method and see if it will work for me.
Further info:
I have inherited an MDB that has a clunky interface and I want to give it a smoother, HTML based, one. This database will be distributed to many locations and there is no central web server upon which to place it. Only the initial data is important to distribute, not any additional data that users my add; so I'm not worried about maintaining the data. It's simply giving sites info for them to start with. Having every site install IIS (or some other web service) would cause more problems than it would fix.
Here is an example:
An MS Access database located at c:\MyProgram\MyDatabase.mdb. Several HTML pages located in the same dir. Shortcut to index.html on the desktop.
When index.html is launched it pulls info from a table in MyDatabase.mdb and displays it. The user then can make changes to the data, click the submit button and MyDatabase.mdb would be update with the changes.
All the files local on the machine.
I hope this clarifies.
Thanks again.
-
1
- #4
- Thread starter
- #6
- Thread starter
- #7
PH,
Thanks for the great info. I finally got the HTA to gather data from Access. I ended up having to use an ADO connection to the ODBC because I couldn't find any code examples of VBS using DAO that would actually work. I believe I saw somewhere that I can set up the ODBC entry with VBS code, so I should be OK there.
Here is my code, in case anyone else is trying to do the same thing. This is the HTML and VBS code (just the basics).
Thanks again to both PHV and jedraw!
Thanks for the great info. I finally got the HTA to gather data from Access. I ended up having to use an ADO connection to the ODBC because I couldn't find any code examples of VBS using DAO that would actually work. I believe I saw somewhere that I can set up the ODBC entry with VBS code, so I should be OK there.
Here is my code, in case anyone else is trying to do the same thing. This is the HTML and VBS code (just the basics).
Code:
<html><head>
<TITLE>Get Student Data</TITLE>
<HTA:Application
ID="GSD"
APPLICATIONNAME="Get Student Data"
Border="none"
Caption="no"
SingleInstance="yes"
WindowState="maximize">
</head>
<script language="VBScript">
option Explicit
On Error Resume Next
sub Window_onLoad
Dim fso, conn, SQuery, Rst, dataOutput
'Creates the DB connection peramiters
set fso = CreateObject("Scripting.FileSystemObject")
set conn = CreateObject("ADODB.connection")
conn.ConnectionTimeout=30
conn.CommandTimeout=30
'connects to the ODBC database
conn.open ="RU"
'Sets the query
SQuery = "SELECT * From Students;"
'executes the query
Set Rst = conn.Execute(SQuery)
'makes sure we start reading at the begining of the table'
Rst.MoveFirst
dataOutput = "<table> "
'loops through the table and writes the data to a var
While Not Rst.EOF
dataOutput = dataOutput & "<tr> "
dataOutput = dataOutput & "<td> " & Rst("ContactID") & " </td> "
dataOutput = dataOutput & "<td> " & Rst("FirstName") & " </td> "
dataOutput = dataOutput & "<td> " & Rst("LastName") & " </td> "
dataOutput = dataOutput & "<td> " & Rst("Address") & " </td> "
dataOutput = dataOutput & "</tr>"
Rst.MoveNext
Wend
dataOutput = dataOutput & " </table> "
'close the DB
Rst.Close
'Writes the table to the webpage
DataArea.InnerHtml = dataOutput
'close all connections
Set fso = Nothing
conn.Close
Set conn = Nothing
End Sub
</script>
<body>
<span id="DataArea"></span>
<p></p>
</html>Thanks again to both PHV and jedraw!
- Status
Similar threads
- Locked
- Question
- Question
- Locked
- Question