Hi!
There are many types of recordsets that allow to add record. You do not require to use Dynamic recordset to be able to add record. For example, connection is adUseClient, recordset is adOpenStatic - allows to add new records pretty well.
HTH.
>Vlad
>
>thanks for the article reference but it doesn't tell me how to add a record.
>As far as I can see the OLE DB Provider for ODBC doesn't support dynamic recordsets which are necessary to be able to add records.
>I must be missing something here because I am sure you must be able to add records somehow.
>
>Nick Mason
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.