Advertisement

05.07.2008 at 01:05PM PDT, ID: 23384117
[x]
Attachment Details

Get Identity after Insert in MS Access and SQL Server back-end

Asked by burtonrhodes in Access Coding/Macros, Microsoft Access Database

Tags: VBA, ACCESS

I know this question is asked daily, but for some reason I can't find a solution that actually works!  I am simply trying to add a record to a table (SQL SERVER Back-end) and get the ID for the record added.  It is a multi-user environment so max(ID) method is not an option.  This seems like a pretty standard procedure.  I would prefer to use DAO, but ADO is an option.  Can someone please help?Start Free Trial
 
Keywords: Get Identity after Insert in MS Access a…
Title
1 ADO and DAO
2 @@Identity or Scope_ID() after inse…
3 Access 2003 - DAO vs. ADO vs…
4 Access 2003 DAO recordset synta…
5 ADO Vs. DAO
6 Identity in MS SQL server
 
Loading Advertisement...
 
[+][-]05.07.2008 at 01:15PM PDT, ID: 21519988

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.07.2008 at 01:18PM PDT, ID: 21520009

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.07.2008 at 01:20PM PDT, ID: 21520039

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.07.2008 at 01:25PM PDT, ID: 21520078

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.07.2008 at 01:33PM PDT, ID: 21520141

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.07.2008 at 01:38PM PDT, ID: 21520173

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.07.2008 at 01:40PM PDT, ID: 21520185

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.07.2008 at 01:44PM PDT, ID: 21520214

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.07.2008 at 02:01PM PDT, ID: 21520323

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.07.2008 at 02:25PM PDT, ID: 21520479

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Coding/Macros, Microsoft Access Database
Tags: VBA, ACCESS
Sign Up Now!
Solution Provided By: burtonrhodes
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628