Am having major problems trying to connect my Access database to my webpage via DreamweaverMX. I created a search button on the webpage and want to search record on the database and also a login page which can be validated by database records.

No simple quick solution you are going to have to take time out and follow a few tutorials/demonstration solutions. A good place to start would be http://www.codeproject.com.

Sorry that’s the answer you were after but your question is not that straight forward to answer, as there are a lot of other factors that need to be considered like security etc.

Quick answer:
1. Ensure database is in wwwroot (iis) or htdocs (apache).
2. If Apache, make sure you have an ASP server (SUNOne or similar) or php / similar
3. In Dreamweaver, create a new page (asp) and use the database link on the application tab in the toolbar to launch the wizard.
 (This only works on a proper copy of Dreamweaver MX, the trials won't let you do this.)
You'll still need to use a bit of common sense to work around the wizard but the help files are pretty easy to understand!

Have fun!