Re: Index number not working properly with variable

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Ronald R. Dodge, Jr. wrote:

The class itself is one that I created myself to address some of the issues
I ran into within DAO coding. It's basically to modulate code so as I only
have to call on the codes within the various forms rather than having to
create codes within the forms themselves.

One of the reasons being, as much as I would like to use bound forms and
controls, the requirements to use such and the requirements of my users
along with my own set of requirements don't quite allow for the use bound
forms. In all actuality, it's not so much my own set of requirements that's
keeping me from using bound forms/controls, but rather with the fact that
I'm having to model to how JDE works to keep the training involved to a
minimal. One of the aspects of it doesn't allow for the use of bound
forms/controls.

ADO also doesn't allow for persistent connection against a Jet Engine
database, so can't really use it either in environments requiring such
connections. Therefore, the only way to use ADO within MS Access would be
to model more or less the ADO.NET coding in a disconnected environment,
though much more limited than ADO.NET set of codes.

Given the above situation, that only leaves DAO coding left even though it's
basically dead in the water as far as any improvements to it is concerned.


I won't try to second guess your use of bound forms.

DAO is NOT dead in the water. A2007 made major changes in
relation to the new ACE file format and several new
features. ADO is the data access library that has had the
bare minimum of updates over the last several versions.

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Re: Index number not working properly with variable
    ... create codes within the forms themselves. ... that only leaves DAO coding left even though it's ... Dim l_lngCurrentTableDefCount As Long, tdf As DAO.TableDef ... Set m_objDAORecordSets = New clsDAORecordSets ...
    (microsoft.public.access.modulesdaovba)
  • Re: Index number not working properly with variable
    ... Guess I stand corrected about the improvement aspect of DAO coding. ... create codes within the forms themselves. ... ADO also doesn't allow for persistent connection against a Jet Engine ... DAO is NOT dead in the water. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Best place to get an error code reader on a Sunday?
    ... Odds are that it got wet and either the multi-plug connector needs ... I think you'd actually need VAG-COM to read and clear the codes, ... Especially if the water has got down into the box ...
    (uk.rec.cars.vw.watercooled)
  • Re: SQL Server Connection Declearation
    ... You need to set a reference to ADO. ... Of course, if you don't have a reference set to ADO, then your program won't ... See the codes below: ... > Private Sub cmdSearch_Click ...
    (microsoft.public.vb.database.ado)
  • Re: Best place to get an error code reader on a Sunday?
    ... Odds are that it got wet and either the multi-plug connector needs ... I think you'd actually need VAG-COM to read and clear the codes, ... the interior of the car is bone dry, ... Especially if the water has got down into the box ...
    (uk.rec.cars.vw.watercooled)