To any one who is reading this......HELLLLLLLPPPPP!! In the last 3 months, I've attempted to use DAO and ADO with Access 2000 but its always been one error message or another. Its either "...too few parameters" or some other message. Is there anyone that can provide me with an IDIOTS GUIDE to implementing ADO on a single table database i.e. retrieving data from the db using a form by passing an SQL query in which the WHERE parameter changes depending on the particular record being sought e.g. User Id. (am i making sense?). In addition, I dont understand the following...whatever they are; adLockOptimistic, adLockReadOnly, cmdTable etc.

To all you Gurus interested in saving a worthless peasant
I've tried to attached a copy of the db, in which you'll find the table, the form and my sorry attempt at using ADO (command button event)
Remember; AN IDIOTS GUIDE is what is needed. Nothing too complicated please