Re: MSAccess and Sequences
From: Stephen Lappin <SL_at_rtel.demon.co.uk>
Date: Fri, 29 Jul 1994 11:50:52 +0000
Message-ID: <775482652snz_at_rtel.demon.co.uk>
Date: Fri, 29 Jul 1994 11:50:52 +0000
Message-ID: <775482652snz_at_rtel.demon.co.uk>
In article <33084_at_uswnvg.uswnvg.com> lreimer_at_uswnvg.com "Lynne Reimers" writes:
> Has anyone used Oracle sequences from MSAccess? I am using MSAccess 2.0 and
> attaching to Oracle7 tables. I would like to be able to generate primary
> key values. Any suggestions?
>
> Lynne
> 206-450-8635
>
Why don't you create an INSERT trigger to get the next sequence number and populate your primary key. I doubt that you could do anything with sequences from within MSAccess
--
Stephen Lappin
+-----------------+ | +-------------+ | Real Time Engineering Ltd. | | Real Time | | Capital House | +-------------+ | 20 Park Circus | Engineering Ltd | Glasgow G3 6BE Tel: +44 (0)41 332 9400 +-----------------+ Scotland U.K. Fax: +44 (0)41 331 2509Received on Fri Jul 29 1994 - 13:50:52 CEST