Re: Use DAO or ADO?

I find many of these to be useful and their function not easily
duplicated in DAO.

ADO Objects

Command Object (ADO)
Connection Object (ADO)
Error Object
Field Object
Parameter Object
Property Object (ADO)
Record Object (ADO)
Recordset Object (ADO)
Stream Object (ADO)

ADO Events
BeginTransComplete, CommitTransComplete, and RollbackTransComplete
Events (ADO)
ConnectComplete and Disconnect Events (ADO)
EndOfRecordset Event (ADO)
ExecuteComplete Event (ADO)
FetchComplete Event (ADO)
FetchProgress Event (ADO)
InfoMessage Event (ADO)
WillChangeField and FieldChangeComplete Events (ADO)
WillChangeRecord and RecordChangeComplete Events (ADO)
WillChangeRecordset and RecordsetChangeComplete Events (ADO)
WillConnect Event (ADO)
WillExecute Event (ADO)
WillMove and MoveComplete Events (ADO)

ADO Collections
Errors Collection (ADO)
Fields Collection (ADO)
Parameters Collection (ADO)
Properties Collection (ADO)
ADO Properties
AbsolutePage Property (ADO)
AbsolutePosition Property (ADO)
ActiveCommand Property (ADO)
ActiveConnection Property (ADO)
ActualSize Property (ADO)
Attributes Property (ADO)
BOF, EOF Properties (ADO)
Bookmark Property (ADO)
CacheSize Property (ADO)
Chapter Property (ADO)
Charset Property (ADO)
CommandStream Property (ADO)
CommandText Property (ADO)
CommandTimeout Property (ADO)
CommandType Property (ADO)
ConnectionString Property (ADO)
ConnectionTimeout Property (ADO)
Count Property (ADO)
CursorLocation Property (ADO)
CursorType Property (ADO)
DataMember Property
DefaultDatabase Property
DefinedSize Property
Description Property
Dialect Property
DataSource Property (ADO)
Direction Property
EditMode Property
EOS Property
Filter Property
HelpContext, HelpFile Properties
Index Property
IsolationLevel Property
Item Property (ADO)
LineSeparator Property (ADO)
LockType Property (ADO)
MarshalOptions Property (ADO)
MaxRecords Property (ADO)
Mode Property (ADO)
Name Property (ADO)
NamedParameters Property (ADO)
NativeError Property (ADO)
Number Property (ADO)
NumericScale Property (ADO)
OriginalValue Property (ADO)
PageCount Property (ADO)
PageSize Property (ADO)
ParentRow Property (ADO)
ParentURL Property (ADO)
Position Property (ADO)
Precision Property (ADO)
Prepared Property (ADO)
Provider Property (ADO)
RecordCount Property (ADO)
RecordType Property (ADO)
Row Property (ADO)
RowPosition Property (ADO)
Rowset Property (ADO)
Size Property (ADO Parameter)
Size Property (ADO Stream)
Sort Property
Source Property (ADO Error)
Source Property (ADO Record)
Source Property (ADO Recordset)
SQLState Property
Status Property (ADO Field)
Status Property (ADO Recordset)
StayInSync Property
State Property (ADO)
Stream Property
Type Property (ADO)
Type Property (ADO Stream)
UnderlyingValue Property
Value Property (ADO)
Version Property (ADO)

ADO Dynamic Properties
ADO Dynamic Property Index
Optimize Property-Dynamic (ADO)
Prompt Property-Dynamic (ADO)
Reshape Name Property-Dynamic (ADO)
Resync Command Property-Dynamic (ADO)
Unique Table, Unique Schema, Unique Catalog Properties-Dynamic (ADO)
Update Resync Property-Dynamic (ADO)

ADO Methods
AddNew Method (ADO)
Append Method (ADO)
AppendChunk Method (ADO)
BeginTrans, CommitTrans, and RollbackTrans Methods (ADO)
Cancel Method (ADO)
CancelBatch Method (ADO)
CancelUpdate Method (ADO)
Clear Method (ADO)
Clone Method (ADO)
Close Method (ADO)
CompareBookmarks Method (ADO)
CopyRecord Method (ADO)
CopyTo Method (ADO)
CreateParameter Method (ADO)
Delete Method (ADO Parameters Collection)
Delete Method (ADO Fields Collection)
Delete Method (ADO Recordset)
DeleteRecord Method (ADO)
Execute Method (ADO Command)
Execute Method (ADO Connection)
Find Method (ADO)
Flush Method (ADO)
get_OLEDBCommand Method
GetChildren Method (ADO)
GetChunk Method (ADO)
GetDataProviderDSO Method
GetRows Method (ADO)
GetString Method (ADO)
LoadFromFile Method (ADO)
Move Method (ADO)
MoveFirst, MoveLast, MoveNext, and MovePrevious Methods (ADO)
MoveRecord Method (ADO)
NextRecordset Method (ADO)
Open Method (ADO Connection)
Open Method (ADO Record)
Open Method (ADO Recordset)
Open Method (ADO Stream)
OpenSchema Method
put_OLEDBCommand Method
Read Method
ReadText Method
Refresh Method (ADO)
Requery Method
Resync Method
Save Method
SaveToFile Method
Seek Method
SetEOS Method
SkipLine Method
Stat Method
Supports Method
Update Method
UpdateBatch Method
Write Method
WriteText Method

On Dec 22, 9:57 pm, "David W. Fenton" <XXXuse...@xxxxxxxxxxxxxxxxxxx>
wrote:

And that's right where I started. ADO for ADPs, DAO for everything
with linked tables. If you're not using linked tables, then you
really oughtn't be using Access at all. In other words, DAO makes
more sense for nearly every realistic scenario. ADO makes little
sense for any Access development.

--
David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/

.

Relevant Pages

  • Re: SET IDENTITY_INSERT tablename ON problem
    ... Try to do next - run SQL profiler and see if ADO Command ... Another way is to use Execute method of ADO connection. ... > database I add a new tmp table with the new structure. ...
    (microsoft.public.vb.database.ado)
  • Re: Problems with ADO Interop and dBASE file
    ... All the hits I found on this error relate to people using ADO.NET, not ADO, so hopefully someone can help me. ... recs, ExecuteOptionEnum.adExecuteNoRecords); ... // YEAR must be escaped because apparently it's a reserved word in dBASE. ... I'd use Profiler to see the exact command that was being passed and diagnose problems from there. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: access97, how to open adodb recordset to a local query
    ... totally defeats the point of using ADO - plus, ... what I need is to create an ADO recordset pointing to "myAccessQuery" ... mdb running the vba or did it open a connection to a second instance ...
    (comp.databases.ms-access)
  • Re: ADO Properties
    ... > ADO.NET has same objects like Connection, Command object as ADO does. ... Where are the equivalent in ADO .NET to the ADO properties? ... its Properties collection in its Connection, Command, and Recordset ActiveX ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADOCommand and grave accent problem
    ... problem - Paolo has spotted the solution. ... a parameterised command I do not know. ... >> when using an ADO Command, and not when using an ADO Connection object. ...
    (borland.public.delphi.database.ado)
Loading