A very simple online project management tool. I was looking for an easy way to keep track of things I was working on, everything else was way over complicated. I quickly created this simple task management solution with ASP and MS Access.
Copy all the files to your web server. The database path is set using the mappath statement, so if you would like to place your database in a different place, then edit line 55 in common.asp.
dbPath = Server.MapPath("projectdb.mdb")
to your path (example):
dbPath = "C:\inetpub\data\projectdb.mdb"
Once setup, the defaut login is "admin", with a password of "1234".
You will see the project list, each heading is sortable desc or asc by clicking on the title, easily change the order of the projects by changing the number and clicking "update order", this will loop through each project and update the sort value. Sample code below.
trFormList = Request.Form("projorder")
strIDList = request.form("id")
if strFormList = "" then
FormList = split(strFormList, ",")
IDList = split(strIDList, ",")
For iLoop = LBound(FormList) to UBound(FormList)
pageorder = Trim(FormList(iLoop))
if not IsNumeric(pageorder) then
pageorder = "1"
id = Trim(IDList(iLoop))
if not IsNumeric(id) then
response.write "<p>Error, not a valid number</p>"
if pageorder > 0 then
set Conn = server.createobject("adodb.connection")
Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath
mySQL = "UPDATE tblproj SET projorder = " & pageorder & " WHERE ID = " & ID & ";"
Simply click on the project name to view and edit the project details
Categories and status values can be edited easily to match your needs.
Users can also me added and changed as needed.
That's it, nothing fancy, but if you need a quick and simple way to keep track of tasks/projects, then give it a try.
Download all files and full source here. ASP Project