By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,659 Members | 1,678 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,659 IT Pros & Developers. It's quick & easy.

Autonumber not updating fast enough

P: 2
I was reading in your forums and found out that SQL does not add an autonumber field until it saved. I have an ACCESS front end database that I use this autonumber to create the MERGEID which is my primary key and key cluster. I need SQL to populate the AUTONUMBER field right away so my VB script can create this MERGEID.

How can I get this done?

Diana
May 24 '09 #1
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
Depends on how your front-end steps goes through. I would recommend you lawt your front-end goes through then after all the input is done, save the data on your form and display everything again with the MERGEID displayed.


--- CK
May 25 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.