ADO, DAO, Chairman MAO

[Newbeee]

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

[Wildec2]

What attachment?

[Newbeee]

Looks like the attachment was too large..... Can you help though?

[barchetta]

If it's about learning Access I would stick to DAO in the first place and forget about ADO, although the latter is newer. Access works best with DAO because DAO is optimized for it. After that go learn some SQL. Then it's time to learn ADO IMHO. Trying two different techniques at the same time can be quite confusing. There are about a million books about Access VB so have a look in the local book shop.

[Newbeee]

barchetta, note that I do know sql quite well, unfortunately having chosen to be an IT business analyst, my VB and sql skills have taken a bit of a dive. In addition, using VBA in MS Access is quite different from using VB. The need to always set focus is one thing that is quite traumatising. However I have been able to connect to the access db using ADO and passing a SELECT query successfully. The problem now is that in VB I have been able to pass SELECT and INSERT queries but VBA does not allow me to pass the INSERT query. It gives me an "Error 2185" ; cant reference a property or method unless blah, blah, blah, has focus..

When I press the debug button my SQL query is highlighted.

Can you help?

[reznor]

First of all, in Access VBA, when referencing the values in text boxes, lose the .text, then it will stop jabbering about not having the focus.
Just to be sure, are you programming in VB or VBA right now?

[barchetta]

Newbeee.
If I were you I would try to find a tutorial about DAO and use SQL queries to pass to the database.
Access handles SQL quite well IMHO and there's no instruction too difficult for Access. You also have the benefit of writing queries that the access wizard can't do for you like queries using UNION.
Date handling can be a mess sometimes but you can overcome those problems.

[Newbeee]

Reznor

I'm using VBA right now...... I've been able to pass all the sql queries successfully using vb but vba seems to be a different beast.