Peter,
If you will not mind, I started this thread to elicit responses from advanced pros like you and buddylee17 for the sake of people like me (Hope I didn't sound sentimental).
Peter, as you asked for my reason for using ODBC driver, please remember that I am a newbie. Also, I have oracle xe installed on my system that I used to connect to the oracle 10g xe database and I want to really establish how to link the database with my web visitor form. I installed and configured MySQL on my server and also installed the MySQL ODBC driver (version 5.1). What the problem is now that I couldn't establish a connection, despite that I supplied all the parameters corectly. All I kept getting is "unable to establish a connection: access denied to user". I left that and decided to try the oracle database connection. The connction was succesful however, I couldn't locate the table I created in the oracle database, when I wanted to link tables in the MS Access. The link table process was succesful for the sample HR table in the database as It appeared among the table list. Based on my explanation, the following issues are bothering me:
Issue 1. My desired destination is successful submission of form data from my website to a database (apart from MS Access)

Issue 2. I just sarted out in SQL (which I find stimulating), can some experienced database administrator put me through by pointing me to specific tutorials?
Issue 3. Could buddy_lee17 or someone who understood him better than I, be more explanatory (I mean step-wisely) on his advice. I shall realy be grateful.