Re: Autonumbers vs Identity Key

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

it's not a SQL Server problem

it is an MDB linked table problem if anything

move to SQL Server Access Data Projects and stfu, quit your whining bitch

sorry that it's SOOOOOO COMPLEX

I mean jesus christ



"dguilbault" <dguilbault@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:E928A3F5-52C5-4800-B33C-571A260343A4@xxxxxxxxxxxxxxxx
Ok...here is what i ended up doing.

I have to do a Me.Recalc...this shows the identity key.
Then I had to add a boolean (bF9) as a public variable.
I then had to make bF9 true before doing the recalc, then set it to False
when done.

I then added code to the events that fired on the recalc, exiting the sub if
bF9 was true.

I also had to add code that adds the new record for any foreign table
identity keys.

WHAT A COMPLETE PAIN!!!!! WHO'S BRIGHT IDEA WAS IT TO MAKE SQL SERVER ONLY
ADD THE IDENTITY KEY AFTER THE RECORD SAVE??????? SHEESH

"Tony Toews [MVP]" wrote:

dguilbault <dguilbault@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Oh if it were only that easy. No...this didn't work.

Please post your code.

Why didn't this work? Did you get an error message?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/


.

Relevant Pages

  • Re: Theres a new Borland Delphi directions survey up
    ... Choosing and Using MSDE 2000 as the Database Engine for Your Application ... The Microsoft SQL Server 2000 Desktop Engine is an alternative ... database engine in Microsoft Access 2002 which enables software developers ...
    (borland.public.delphi.non-technical)
  • Re: The data was added to the database but the data wont be displayed
    ... replication with queued updates (SQL Server 2005), ... When inserting records into a Microsoft SQL Server database from an ... Microsoft Access tries to reselect the newly inserted record to ... subscriber) are SQL Server 2000. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Need some query design help....
    ... is "Microsoft Access Developers Guide to SQL Server." ... > "John Viescas" wrote in message ... >> Let's say, for example, that you have Customers as a selection on your ...
    (microsoft.public.access.queries)
  • Re: Microsoft Support for Microsoft Access and ADPs
    ... I have been hearing rumours, from Microsoft Product Support Technicians, ... particular .adp projects and SQL Server Client Data Manager Interface (CDM ... position in regard to continuing support for Microsoft Access and SQL Server ...
    (microsoft.public.access.adp.sqlserver)
  • RE: SQL server failed to call Excels library after ms03-026 patch applied
    ... VBA environment in Microsoft Access successfully, ... related to SQL Server. ... contacting PSS and opening a Support incident troubleshoot this further. ...
    (microsoft.public.sqlserver.security)