RSS

Re: Frontend HTML, Backend MS Access Database??

Please support our Database Design advertiser: Programming Forums

Frontend HTML, Backend MS Access Database??

•

Join Date: Jun 2005

Location: Texas

Posts: 120

Reputation: jwshepherd is an unknown quantity at this point

Rep Power: 4

Solved Threads: 5

jwshepherd jwshepherd is offline

Offline

Junior Poster

Re: Frontend HTML, Backend MS Access Database??

Jun 16th, 2005

I use asp , but this will get you connected to the database from then on its standard sql language (just about )

Help with Code Tags

(Toggle Plain Text)

Set cnDatabase = Server.CreateObject("adodb.connection")
cnDatabase.Open "DBQ=" & "C:\InetPub\wwwroot\Database\db.mdb" & ";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;MaxBufferSize=8192;Threads=20;", "username", "password"

set rsRecordset = cnDatabase.Execute("Select Count(*) AS RecCount From Tips")
numRec = rsRecordset("RecCount")
set rsRecordset = nothing

DaniWeb Home > Forums > Web Development > Databases > Database Design > Frontend HTML, Backend...

Re: Frontend HTML, Backend MS Access Database??

Frontend HTML, Backend MS Access Database??

Re: Frontend HTML, Backend MS Access Database??