ASP with Access Database

My boss wants me to write a intranet webpage (can be in ASP / HTML) to connect our Access Database and to search in the Database.

We are using WinNT Server here, and php is not allow. And i have no permission to install anything to the server ...

I have experience with php and mySQL, but have no experience with asp ...

1. what is ODBC ? how to link db with ODBC in intranet ?
(coz' i only saw instructions to link db to local computer)

2. any sample codes of ASP with access database to follow?

Please help! Thx

There are lots of tutorials at www.4guysfromrolla.com

wow! your situation is like mine, differece is that there are already asp pages in the intranet, but my boss told me that if i can convert asp to php,i can continue the intranet with my php pages. But i do not know how to convert asp to php.

The basic logic behind an ASP application is very similar to that of a PHP application, so there really isn't anything to be terrified of.
W3schools has tutorials as well on connecting databases to the ASP pages.
Converting from ASP to PHP isn't really that difficult either, but I haven't found any tools that really did a good enough job to think they would save me time.
Just had to learn both and translate myself...

thanks oldJacques. today, the condition changed, my boss told me that I do not need to continue the ASP pages and the Access database, I can make a new intranet with PHP and MySQL. That's sounds better

There is a program that will convert ASP to php. You would of course need to change the data access portions of the code and probably a few other pieces.

I've used it before, but only once or twice.

http://asp2php.naken.cc/

thanks lordkyl! i'll try it and tell you the result.

I have a very similar project of my own at my office. I'm also making an intranet site using ASP and it will also have database connectivity. Seems like this is a popular thing to do these days! I was just wondering whether ASP can connect to an Access database, and if so, how practical is this? Thanks.

Kinda off topic for this thread, you wil probably get alot more answers if you posta new one.

Having said that, using ASP with MS Access is a very viable option for a small application. There are litterally hundreds of books and tutorials on the web. I just did a quick search on google and found this one

http://www.vallin.com/pub/1/asp1.asp

If you post a new thread, someone might be able to recommend a better sight or a good book.

good luck!

or..check out this thread http://forums.devshed.com/t52490/s.html