Re: Can and Can't insert using DAO on SQL Server linked table

From: Mark A. Sam (msam_at_Plan-It-Earth.Net)
Date: 09/05/03 

Date: Fri, 5 Sep 2003 09:13:11 -0400

David,

It is what I thought also. I don't think Identity Insert is the issue here,
possibly the error message is wrong.

God Bless,

Mark

"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:evDOfn0cDHA.1032@TK2MSFTNGP11.phx.gbl...
> I think/thought that Identity Insert is supposed to be on
> for only one table at a time in the database. This would
> suggest that there was some odd behaviour that for some
> reason occasionally set identity_insert on this one table.
>
> thanks for your continued feedback
>
> (david)
>
>
> "Synergy" <NoName@NoMail.Com> wrote in message
> news:etX0RmucDHA.1280@tk2msftngp13.phx.gbl...
> > I resolved this issue, but writing a function to delivering the next ID
> > number (to the Identity Field) and assigning it before executing my DAO
> > Update method.
> >
> > This would suggest that Identity Insert was engaged on that table, but
> there
> > was no problem populating other subtables with Identity Fields.
> >
> > God Bless,
> >
> > Mark A. Sam
> >
> >
>
>

Relevant Pages

  • Re: Couldnt log in- Local date and time different from network
    ... >> Thank you and God Bless, ... >> Mark A. Sam ... > default setting is 5 minutes, so if your computer time is faster or slower ... > better idea to 'check your Outlook calendar' because of this issue. ...
    (microsoft.public.windowsxp.general)
  • Re: Cannot Set recordset in A2003
    ... Thank you Paul. ... Mark ... >>> positioned below the DAO library or that it is turned off. ... >> God Bless, ...
    (microsoft.public.access.formscoding)
  • Re: Setting up DSN through Code
    ... Are you saying your procedure will address a remote server through the ... >> an SQL database through the internet and wonder how the application can ... >> Thanks and God Bless, ... >> Mark A. Sam ...
    (microsoft.public.access.modulesdaovba)
  • Re: #Name? in A2003
    ... refresh after the recordset is loaded. ... Mark ... >> Doesn't Acess 2003 allow reading the recordset clone of a subform? ... >> God Bless, ...
    (microsoft.public.access.forms)
  • Re: Taskbar moved
    ... > Try left-dragging with the mouse to the bottom of the screen. ... > MS-MVP Windows Shell/User ... >> Thanks and God Bless, ... >> Mark A. Sam ...
    (microsoft.public.windowsxp.general)
Quantcast