Database Design

Frontend HTML, Backend MS Access Database??

Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2005

Posts: 3

Reputation: andrewgowland is an unknown quantity at this point

Solved Threads: 0

andrewgowland andrewgowland is offline

Offline

Newbie Poster

Frontend HTML, Backend MS Access Database??

Apr 19th, 2005

Hi everyone, im really stuck! I need to create a front end web site with a back end access database for my module at university. i have no idea how to do it!! do i create the web page and then create forms within the page and then link it to access?????

Any help would be greatly appreciated

•

Join Date: Feb 2005

Posts: 355

Reputation: DanceInstructor is an unknown quantity at this point

Solved Threads: 14

DanceInstructor DanceInstructor is offline

Offline

Posting Whiz

Re: Frontend HTML, Backend MS Access Database??

Apr 19th, 2005

Is it required that you use access?

Clear Mind Hosting and Web Design

If I've helped you please consider adding to my reputation.

•

Join Date: Apr 2005

Posts: 9

Reputation: rhenerlau is an unknown quantity at this point

Solved Threads: 0

rhenerlau

Offline

Newbie Poster

Re: Frontend HTML, Backend MS Access Database??

Apr 20th, 2005

Access is not the best choice for this kind of application. Unless you are required to use access (part of a class assignment or something) you would be better off looking into either Oracle or Microsoft Structured Query Language (SQL) Server. Those applications are built for large scale databases, Access is built to handle small-scale applications. Hope this helps!

Richard

•

Join Date: Apr 2005

Posts: 3

Reputation: andrewgowland is an unknown quantity at this point

Solved Threads: 0

andrewgowland andrewgowland is offline

Offline

Newbie Poster

Re: Frontend HTML, Backend MS Access Database??

Apr 22nd, 2005

•

Originally Posted by DanceInstructor

Is it required that you use access?

Thanks for replying, yes it is...thats the problem. i would have used SQL if i was alowed, any suggestions?

•

Join Date: Apr 2005

Posts: 3

Reputation: andrewgowland is an unknown quantity at this point

Solved Threads: 0

andrewgowland andrewgowland is offline

Offline

Newbie Poster

Re: Frontend HTML, Backend MS Access Database??

Apr 22nd, 2005

•

Originally Posted by rhenerlau

Access is not the best choice for this kind of application. Unless you are required to use access (part of a class assignment or something) you would be better off looking into either Oracle or Microsoft Structured Query Language (SQL) Server. Those applications are built for large scale databases, Access is built to handle small-scale applications. Hope this helps!

Richard

Thanks for replying, yes i have to use access, its a nightmare, i would have used SQL but they want us to use Access only. andy suggestions?

•

Join Date: Jun 2005

Posts: 121

Reputation: jwshepherd is an unknown quantity at this point

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