Prev: What is the key code for Microsoft Office 2010
Next: Vista and 2002-2003 database
From: Tony Toews [MVP] on 20 Apr 2010 16:42
"David W. Fenton" <XXXusenet(a)dfenton.com.invalid> wrote:

>Over on StackOverflow someone was asking about how to get the last
>Autonumber value, and I suggested SELECT @@IDENTITY in the same
>connection as the insert is made, and said "just like SQL Server."

David

You want to write up an article on this and I'll post it as a blog?
Or should I just write up a paragraph mentioning this thread?

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
From: dj on 2 Oct 1920 14:45

"Tony Toews [MVP]" <ttoews(a)telusplanet.net> wrote in message
news:oc4ss51unpidbu6kj01alpfi02a2r5sc1e(a)4ax.com...
> "David W. Fenton" <XXXusenet(a)dfenton.com.invalid> wrote:
>
>>Over on StackOverflow someone was asking about how to get the last
>>Autonumber value, and I suggested SELECT @@IDENTITY in the same
>>connection as the insert is made, and said "just like SQL Server."
>
> David
>
> You want to write up an article on this and I'll post it as a blog?
> Or should I just write up a paragraph mentioning this thread?
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
> For a convenient utility to keep your users FEs and other files
> updated see http://www.autofeupdater.com/
> Granite Fleet Manager http://www.granitefleet.com/

From: David W. Fenton on 21 Apr 2010 14:28
"Tony Toews [MVP]" <ttoews(a)telusplanet.net> wrote in
news:oc4ss51unpidbu6kj01alpfi02a2r5sc1e(a)4ax.com:

> "David W. Fenton" <XXXusenet(a)dfenton.com.invalid> wrote:
>
>>Over on StackOverflow someone was asking about how to get the last
>>Autonumber value, and I suggested SELECT @@IDENTITY in the same
>>connection as the insert is made, and said "just like SQL Server."
>
> You want to write up an article on this and I'll post it as a
> blog? Or should I just write up a paragraph mentioning this
> thread?

The post you replied and the StackOverflow discussion is all I have
to say about it (I don't blog about Access!). I'd like someone on
the Access team to be asked about this, to be honest. It seems to me
to be a significant issue, what with A2010 having the equivalent of
triggers now.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
First  |  Prev  | 
Pages: 1 2
Prev: What is the key code for Microsoft Office 2010
Next: Vista and 2002-2003 database