•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 397,749 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,619 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser:
Views: 16377 | Replies: 5
 |
•
•
Join Date: Apr 2005
Posts: 3
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
Any help would be greatly appreciated
•
•
Join Date: Feb 2005
Posts: 354
Reputation:
Rep Power: 4
Solved Threads: 12
Posting Whiz
Is it required that you use access?
•
•
Join Date: Apr 2005
Posts: 5
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
Richard
•
•
Join Date: Apr 2005
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
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:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
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
Location: Texas
Posts: 120
Reputation:
Rep Power: 4
Solved Threads: 5
Junior Poster
I use asp , but this will get you connected to the database from then on its standard sql language (just about )
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 |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
Linear Mode
•
•
•
•
access avatar backup breach code combo creative daniweb data data protection database design development div dreamweaver dropdownlist firefox google checkout google checkout vat government hacker howto html html api ibm illustrator javascript medicine module ms net news normalization photoshop print research reuse security server sql survey symantec tables toread tutorials w3c web wysiwyg xml
- how to connect ms access database to html webpage (JavaScript / DHTML / AJAX)
- Two Issues With Access Database App (MS Access and FileMaker Pro)
- MS Access database and java (Java)
Other Threads in the Database Design Forum
- Previous Thread: Help
- Next Thread: Can anyone help me here!
