Ad:

Database Design Discussion Thread
Unsolved
Views: 37268

Apr 19th, 2005

Frontend HTML, Backend MS Access Database??

Expand Post »

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

Similar Threads

how to connect ms access database to html webpage in JavaScript / DHTML / AJAX
Two Issues With Access Database App in MS Access and FileMaker Pro
MS Access database and java in Java

andrewgowland

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Apr 2005

Permalink

Apr 19th, 2005

Re: Frontend HTML, Backend MS Access Database??

Is it required that you use access?

DanceInstructor

Reputation Points: 17

Solved Threads: 14

Posting Whiz

Offline

355 posts
since Feb 2005

Permalink

Apr 20th, 2005

Re: Frontend HTML, Backend MS Access Database??

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

rhenerlau

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Apr 2005

Permalink

Apr 22nd, 2005

Re: Frontend HTML, Backend MS Access Database??

Quote 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?

andrewgowland

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Apr 2005

Permalink

Apr 22nd, 2005

Re: Frontend HTML, Backend MS Access Database??

Quote 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?

andrewgowland

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Apr 2005

Permalink

Jun 16th, 2005

Re: Frontend HTML, Backend MS Access Database??

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

(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

jwshepherd

Reputation Points: 20

Solved Threads: 5

Junior Poster

Offline

123 posts
since Jun 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Database Design Forum Timeline: Help

Next Thread in Database Design Forum Timeline: Can anyone help me here!

DaniWeb Message

Cancel Changes

User Name
Password