Change the bit field to tinyint or some other numeric. Duane Hookom MVPMS Access
> From: dbalorenzini@yahoo.com
> 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]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar