Re: Autonumber an Oracle field with Access97 via odbc?

Hi Lyle,

You can call a function in the Before update event of your form to attribute the next number to your record. Use the DMax function to determine that number.

-- 
Gaetan Fournier
Info GRH
Quebec, Canada
infogrh_at_sympatico.ca


Lyle Homer <lhomer_at_xmission.com> a écrit dans l'article
<340ee583.72000624_at_news.alt.net>...


> 

> I moved an access97 table onto an oracle 7 server and am able to

> get at and update the data via odbc, but the autonumber fields no

> longer work.  (obviously, they're just number fields in the oracle

> table now)

> 

> Is there anyway to make access control the numbering of this field

> when a new record is added?  Is there such a thing as a

> psuedo-autonumber? How do I go about setting up something like this?

> 

> Thanks for any reply,

> 

> Lyle

> lhomer_at_xmission.com

> 

>