--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> Change the bit field to tinyint or some other numeric. Duane Hookom MVPMS Access
>
> > From: dbalorenzini@...
> > Date: Wed, 27 Mar 2013 02:44:56 +0000
> > Subject: [MS_AccessPros] Access 2013 and SQL Server issue
> >
> > I have create a SQL Server table called tblStructure. There are 4 fields in it:
> >
> > StructureID int PK
> > MaintDate datetime
> > MaintTypeID int
> > Active bit DEFAULT VALUE 0 Allow Nulls
> >
> > I have an access 2013 form which links these fields, however when I click on my Active checkbox I get the following error:
> >
> > The Microsoft Office Access database engine stopped the process because you and another user are attempting to change the same data at the same time
> >
> > I looked this up and it tells me how to handle bit field which is basically is to give it a default value. Which I did but it still pop this error. I am at a lost. I have other tables that have bit fields in them and this does not occur. Please advise.
> >
> > Thank you
> >
> > Art Lorenzini
>
> [Non-text portions of this message have been removed]
>
Add a TimeStamp field to asny SQL Server table that contains a Bit data type and make sure the default is set on the Bit field. All will be fine then.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar