ASP Code to Read from a .mdb access file

Recently a collegue contacted me for some help with his university degree. The project was to create a website that was backed by a database. My background is mainly PHP and MySQL however, the course had been teaching them how to manipulate an MDB Access Database file using ASP. The outline of the task was a document management system for projects.

  • A user would enter their unique company number into a page
  • It would list available projects for that company
  • User would select the project and login with a username and password
  • The website would list all files which he had permission to access

The tutorials the lecturer had given out used dreamweaver to create the ADODB.Connection , however it seemed an over complicated way of doing it. After a bit of online research my first ASP project is below ( Could be better but only had an evening to do it! )

index.asp

code here : http://pastebin.com/7s739FKa

This code manages the Company ID input then list the projects from that company

login.asp

Takes the project ID from index.asp and checks the permissions table after username and password verficiation for files they have access to

code here聽 : http://pastebin.com/BmNiXZgz

db.mdb

File here : http://www.pariswells.com/upload/db.mdb

4 Tables

Users -> Username , Password and ID

Projects -> Project Name , Company ID Associated with that Project and Project ID

Permissions -> FileID and UserID

Company -> Company Name , Company Number and ID

 

Definitely prefer PHP to ASP!

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Tags: ASP Code to Read from a .mdb access file, Inner Join Asp, mdb asp lookup, query mbd with asp

Trackback from your site.