Art
After you set a default for the bit column did you update all the records? If not, they are still null and Access freaks out over null bits.
And you also have to relink your SQL table or Access won't see the change.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@...> wrote:
>
> 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 (4) |
Tidak ada komentar:
Posting Komentar