Bill,
You are exactly right. The bit field had a number of null records in it. I filled in the value and bam! It works.
Thanks.
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
alorenzini@crhanetwork.org
"Only those who will risk going too far can possibly find out how far one can go."
________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, March 27, 2013 9:42 AM
Subject: [MS_AccessPros] Re: Access 2013 and SQL Server issue
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 mailto:MS_Access_Professionals%40yahoogroups.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
>
[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 (5) |
Tidak ada komentar:
Posting Komentar