MS Access DB To Webpage Connection ?

ok .. i have this little problem i am going through ... Leme explain this project of mine first .

I have a MS Access DB of student fields like ID no, Name, Marks .. etc .. This one Access DB would be updated by just adding more rows and would be done on the server. It looks sumthing like this:

Now .. I have a HTML page that shows this :

I would enter the ID number of a student (no authentication .. anyone can access anybodys marks), and when i hit submit .. I would be taken to a page that gets the values from the ID specified and shows it in the next page. The page design would be the same .. just the values comming in will depend on the ID number inputed in the previous screen.

The result should be something like this :

Is it possible to make a system like this ? To test this .. i will be using my own asta account .. so i guess if it works here .. then this system can be accessed from anywhere. Secondly, what language would be used ? HTML, PHP or ASP .. i'd preffer HTML .. but since HTML doesnt allow dynamic updating .. i am fine with PHP. But it would be nice if someone helped me out with this.

I think ..

Page1 : Enter ID ---> HTML

Page2 : Show results ---> PHP

DB : MS Access ..

Hope i didnt confuse, if so please let me know .. i'll try to explain in a better way if i can.

Regards

Dhanesh.

Arggggg ... Is the no one who can help this little code troubled .. frustrated .. irritated .. kid ! :unsure:RegardsDhanesh.

First of all, please do not double post. Second, you could put this data in a MySQL database and have a php page which downloads and checks information.

How the script should work:

A page called main.php (or whatever filename you want) should check if the student id exists, then go to results.php (or whatever filename you want). Then it should download the data from the database and show the details. Then it checks if the marks are higher then 75(or the pass level) and it displays "PASS!" or "FAIL!".

I suggest you google a good mysql and php tutorial.

Hope this helps,

souradipm

With much due respect (which by the way, u didnt have) , it wasent a double post with an intention to spam. A double post is considered ONLY if someone makes a consecutive post in a span of say 1 hr or 2 .. depending on the forum rules.

Now, for the post you made, it was EXACTLY the same thing i asked as a question. I know how it would work, I just need some code to get me started. And yes, i have gone to php sites and searched for this, but i was unable to get a decent tutorial.

Well, so next time please do not repeat the posts in your own words to gain points ..

Regards

Dhanesh.

Edit: I know it can be done in MySQL, and i have a working model, but my specifics include an MS Access DB

OK dhanesh,
I found a good database class library compatitable with access:
http://forums.xisto.com/no_longer_exists/
It uses PHP.

Sorry if I was rude to you or anything,
souradipm

Ok well i decided to go with PHP since access was not a good idea ... i created a few things in php and mysql .. but it shure hell is driving me nuts .. will post a new topic with my experiments :unsure:RegardsDhanesh.

You are able to connect toMicrosoft Access using JavaScript when the HTML file is run locally andThe Access .Mdb file is accessible to the file system.  In rare cases, this can be a very cool thing...

I had a situation where this functionality was actually useful, so IWrote a JavaScript library to simplify the process. I had a great dealOf difficulty finding information or examples of how to connect toAccess, so I decided to share my codewith the world... The library is called ACCESSdb and you can get it here!

Hi Dhanesh,

I'm srinivas. I'm expecting the codes to access datas from the same DB you are currently using... Also need the codes for writing the datas to the same database.. Could you pls provide me the datails.

This is my ID : malu_siva123@yahoo.Com

I'm expecting your reply. Pls help me here!

your explanation good but i need the coding to connect html to access

your explanation good but i need the coding to connect html to access