Soldato
We have an Access DB which holds training data. We want to display the contents of the Access DB in a web page (read only).
Is this reasonably easy to do?
Is this reasonably easy to do?
Displaying MS Access Data in a Web Page
- Thread starter Domo
- Start date
Soldato
You'll need to use a server side language such as ASP (possibly PHP if it can connect to Access).
Do you know what your hosting supports?
Do you know what your hosting supports?
Its internal on our Intranet server which already hosts ASP.
I remember doing something with SQL once and it all seemed quite simple! Obviously not!!
Would it be easier to accomplish this using SQL as opposed to Access?
I remember doing something with SQL once and it all seemed quite simple! Obviously not!!
Would it be easier to accomplish this using SQL as opposed to Access?
This is pretty easy in ASP. You need something like:
(Or better code, that's just a quick example!) And then process the recordset however you need to...
Code:
Dim dbConn, strConn, strSQL, recSet, passedID
strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=PATH/FILENAME.mdb; Persist Security Info=False"
strSQL = "SELECT * FROM Whatever"
set dbConn = server.createobject("adodb.connection")
set recSet = server.createobject("adodb.recordset")
dbConn.open strConn
recSet.open strSQL, dbConn(Or better code, that's just a quick example!) And then process the recordset however you need to...
Last edited:
Thanks AJK. Funnily enough - I've just gone to actually start on the work required and it turns out to be Interbase. Terrific! Going to get a data dump scheduled instead! 