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
Sioux Falls, SD
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar