SQL or Recordset connections.

[FGM]

Is there a place to read more about the commands
needed in Access 2002 for using ADODB.Recordset etc.
What I used in Access 97 does not seem to work and I have
forgotten some. Need refresher. Books that I have do not
seem to be clear on commands?

Dim cnn1 as ADODB.Connection
Dim rstEmployees As ADODB.Recordset
Dim strCnn as String
Dim varDate as Variant

or
Dim dbsNorthwind as Database
Dim rstEmployees as Recordset


I am trying to read records from a table and update some
fields as each record is read if it meets the criteria.
Using loop until EOF.

What do I need once connected?

rstEmplyees!fname = "Bill"
rst.Update?

I have a few books mostly 97 & 2000 but can not seem to
find the answers that I need.
Any help would be appreciated or book that is good.
Thank you.

 

[Brian]

Is there a place to read more about the commands
needed in Access 2002 for using ADODB.Recordset etc.
What I used in Access 97 does not seem to work and I have
forgotten some. Need refresher. Books that I have do not
seem to be clear on commands?

Dim cnn1 as ADODB.Connection
Dim rstEmployees As ADODB.Recordset
Dim strCnn as String
Dim varDate as Variant

or
Dim dbsNorthwind as Database
Dim rstEmployees as Recordset


I am trying to read records from a table and update some
fields as each record is read if it meets the criteria.
Using loop until EOF.

What do I need once connected?

rstEmplyees!fname = "Bill"
rst.Update?

I have a few books mostly 97 & 2000 but can not seem to
find the answers that I need.
Any help would be appreciated or book that is good.
Thank you.

I'm assuming that your data is in an mdb file and not SQL Server.

I think you are confusing ADO and DAO. Don't worry, it's Microsoft's fault,
not yours: up to Access 97, DAO was the only choice available to you.
However, in Access 2000 and later, Microsoft, in it's infinite wisdom, gave
you by default a reference to the
once-new-but-now-obsolete-and-never-any-good ADO, and no reference to DAO.

Go to your References window, remove that pesky reference to ADO, and
restore the reference to the sainted DAO. Then, just carry on doing things
the way you did in Access 97. You know it makes sense.

n.b. in the more recent versions, finding DAO stuff in the help system is
like pulling teeth. It's there, but very hard to find. I often have Access
97 open even while working in later versions, just so's I can use it's far
superior help system.

 

[FGM]

Thank you Brian.

I never heard that about ADO and thought that was what we
had to use now?
However, I cannot find the correct information for DAO
and connections for using recordsets etc.
Do you have an example that you could post?
You were right I am only in Microsoft Access 2002 and not
connecting to a server.
I have a table that I want to change other than from a
query.

Thanks if you have any good information on using DAO in
2002.