Try: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;

And, as a matter of personal prefreance, i suppose, i never hard coded the path to the mdb file.

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &Server.MapPath("mydatabase.mdb") &";"

You can also refer to http://www.connectionstrings.com

================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========