Re: How To Return Record Number From AddNew

Jeff Gaines wrote:
On 27/08/2007 in message <uw3PF5L6HHA.5316@xxxxxxxxxxxxxxxxxxxx> Bob
Barrows [MVP] wrote:

PS. Why are you using classic ADO in a .Net application? You should
be using ADO.Net. You should post ADO.Net questions to this group:
microsoft.public.dotnet.framework.adonet

It's historical, I moved to C# from VB6 and converted what I was used
to. It also seems to me that ADO.NET is geared towards using
Datasets/Data Adaptors and although I did try I could never get the
results I wanted, it's much simpler to me to hand code these things.

After going through the VS2005 help file I have found a comment that I
need Access 2000 or later to support the @@IDENTITY property. I do
have Office XP which includes Access 2000 and the equivalent versions
of Word and Excel. I tried it once and found it was the first of the
MSFT bloatware, silly help windows popping up all over the place, and
Word in an SDI style so if you are working on 10 documents you have
10 instances of Word running, ridiculous. I un-installed it and
haven't considered "upgrading" again. I guess I could just try Access
2000, or perhaps put the SQL server desktop engine on the PC.


You don't need Access 2000 to create a Jet 4.0 database, unless you are
intending to use the Access environment to work with it. You can use
ADOX to create the database ...
http://classicasp.aspfaq.com/general/how-do-i-create-a-database-from-asp.html

--
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: ? re. Legal Apps? & ODBC?
    ... based connections (SQL Server & Sybase SQL Anywhere) ... Universal Data Access & Virtual Database Technology Providers ... > All responses should be made to this newsgroup within the same thread. ... >> MVP Entourage ...
    (microsoft.public.mac.office.entourage)
  • Re: maxrecords property doesnt work for me
    ... "ORDER BY q.ScoreDate ASC" ... Of course, I don't have access to your database so I can't test this, ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: number comparison
    ... dateAccrueVation has priority 1 if compared to ... database, then depending on which database, you can probably achieve ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ...
    (microsoft.public.scripting.vbscript)
  • Re: Multihomed DNS Server Mailserver Webserver Fileserver
    ... Kevin D. Goodknecht posted their thoughts, ... Newsgroup Etiquette: ... Please direct all replies to the newsgroup so all can benefit. ... Ace Fekay, MCSE 2000, MCSE+I, MCSA, MCT, MVP ...
    (microsoft.public.win2000.dns)
  • Re: Multihomed DNS Server Mailserver Webserver Fileserver
    ... Kevin D. Goodknecht posted their thoughts, ... Newsgroup Etiquette: ... Please direct all replies to the newsgroup so all can benefit. ... Ace Fekay, MCSE 2000, MCSE+I, MCSA, MCT, MVP ...
    (microsoft.public.windows.server.dns)