ACCESS FEED: [MS_AccessPros] Re: Access 2013 and SQL Server issue

Rabu, 27 Maret 2013

[MS_AccessPros] Re: Access 2013 and SQL Server issue

Art - I get one right every once in a while.
Bill

--- In MS_Access_Professionals@yahoogroups.com, Art Lorenzini <dbalorenzini@...> wrote:
>
> 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@...
> â€œOnly those who will risk going too far can possibly find out how far one can go.â€
>
>
> ________________________________
> From: Bill Mosca <wrmosca@...>
> 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]
>