Inserting record with Microsoft Access

[Albert Leibbrandt]

jeffhg582003 wrote:

>Hi,
>
>I am developing a python script which add records to 
>a microsoft access tables. All my tables have autogenerated number
>fields. I am trying to capture the number generated from the insert but
>I am not exactly sure how to do that after an insert.
>
>Thanks,
>Jeff
>
>
>
>  
>
I had to do something similiar in sql server and the experts back then 
told me that the only way is to write a stored procedure. aparently sql 
server does not have sequences and I am guessing that access is the same.

cheers
albert

-- 
Albert Leibbrandt
Data Manager
CompuScan Holdings (Pty) Ltd
Brandwacht Office Park
Stellenbosch.
South Africa.
Tel;+27 (0)21-8886000
Fax;+27 (0)21-8832336
National: 0861 51 41 31
E-Mail : albert at compuscan.co.za

www.compuscan.co.za - reducing credit risk and fraud, at the same time protecting the consumer against over-indebtedness and reckless borrowing

www.techtonic.co.za - a software design and development, information management and internet solutions company

www.csti.co.za - a skills training and development provider to the Micro Finance sector (BANKSETA accredited)

Confidentiality:
"The information contained in this e-mail and any attachments thereto is private and confidential and is intended for the eyes of the addressees only. Access to this e-mail by any other person or any attachment is not authorized and accordingly prohibited. If you are not the authorized and intended recipient, any disclosure, copying, dissemination or distribution, any other action of omission by you with respect to the information in this e-mail and attachments is prohibited and unlawful."