Re: What's the best way to open a recordset for insert only?

Just in case you really wanted an answer to your question, I suppose I've
been conditioned by a SQL environment I used to work with (not SQL Server,
and defnitely not compliant with any known standard) that would only allow
inserts directly into tables.

"Bob Barrows [MVP]" wrote:

Spencer wrote:
Do you mean:

rs.Open "SELECT * FROM +m_rsname+" WHERE 0=1", m_conn, adOpenStatic,
adLockBatchOptimistic, adCmdText

will let me call rs.AddNew ?



Yes, why wouldn't it?


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.



.

Relevant Pages

  • Re: How to get a header image (logo) wider than page margins
    ... please post all follow-ups to the newsgroup so ... but not separate left and right margin settings ... >> applied to the Odd Page Header and Even Page Header, ... >> Microsoft MVP ...
    (microsoft.public.word.pagelayout)
  • Re: headers
    ... > Microsoft MVP ... now how do I set different margins for different ... >>> rather than resetting the header margins. ... >>> This message is posted to a newsgroup. ...
    (microsoft.public.word.newusers)
  • Re: Page Number
    ... appear--in the header or the footer. ... please post all follow-ups to the newsgroup so ... >> Microsoft MVP ...
    (microsoft.public.word.pagelayout)
  • Re: grid scroll
    ... Microsoft MVP ... Please reply only to the newsgroup so that others can benefit. ... > is it possible for a datagrid to scroll keeping the header in absolute ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Graphic in Header
    ... Microsoft MVP ... please post all follow-ups to the newsgroup so ... > other word.doc into your header. ... Please post replies ...
    (microsoft.public.word.docmanagement)