I want to make an insertion form where you can add a new client. And when this form is filled in and you press the submit button I want to go to a new page where the client id (which is automaticly generated and not filled in) will be passed to.

The Insert Record With Identity looked like an solution to me:www.udzone.nl/showDetail.asp?TypeId=3&NewsId=195
But since I don't have a "Jet OLEDB Provider 4.0" I get an error, when using this extension.

<b>How can I solve this problem without making use of the extension: Insert Record With Identity?</b>

Not sure if this applies to you, since you use Jet dbase driver, BUT in SQL server you can do a

SELECT @@IDENTITY

then again:
support.microsoft.com/default.aspx?scid=kb;en-us;Q232144
this is also relevant:
support.microsoft.com/default.aspx?scid=kb;en-us;Q163446

Hope that helps alittle.

With kind regards,

Dennis van Galen
Webmaster KPN Services
Financial and Information Services

I have found another solution to my problem, but thanks for your help <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

How did you resolve this one?

UD4 | ASP | VBScript | ACCESS | IIS5

You can still write a tutorial about this and enter the competition?!

Martha Graham

I "solved" this problem by showing the data of the newly inserted client in a new page after the insert record.

I made it a sort of validation page for my assignment.

I used:

SELECT top 1 *
FROM client
ORDER BY clientId DESC

to get the date from the last inserted client. With that new data I could pass the clientId.


Another sort of solution for this problem might be found at:
www.udzone.nl/showDetail.asp?TypeId=2&NewsId=385

Edited by - on 15 Nov 2002 15:39:20