December 14, 2012 at 8:56 am
Help needed here.
I've got an Access front-end linked to a SQL Server DB. The recordSource of one of the Access forms is a [simple] table, but none of the fields is updateable from the Access form. It basically throws an error message (see screenshot).
At first I thought it was the code in the form (Load event), but I can't even update the table when I open it on Access (NOT using the form). So it looks as if the table has some type of lock in it.
This is the table creation script.
USE [nameof_DB]
GO
/****** Object: Table [dbo].[tblSites] Script Date: 12/14/2012 15:38:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblSites](
[SiteID] [varchar](50) NOT NULL,
[PartID] [int] NULL,
[IDCheckSum] [varbinary](120) NULL,
[Barcode] [varchar](50) NULL,
[SName] [varchar](50) NULL,
[Addr1] [varchar](50) NULL,
[Addr2] [varchar](50) NULL,
[Town] [varchar](50) NULL,
[County] [varchar](50) NULL,
[Postcode] [varchar](50) NULL,
[Interested] [bit] NULL,
[Type] [varchar](20) NULL,
[IMD] [varchar](20) NULL,
[Phone] [varchar](50) NULL,
[Email] [varchar](50) NULL,
[Notes] [text] NULL,
CONSTRAINT [PK_tblSites] PRIMARY KEY CLUSTERED
(
[SiteID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
Any advice or idea on why this is happening?
Thanks in advance, A.
December 14, 2012 at 9:03 am
A quick google search of your message shows that this is very frequently caused by having a bit field in sql that has no default. Do a search for "write conflict this record has been changed by another user" and you will find tons of links to forum posts with this same exact issue.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 14, 2012 at 9:23 am
Thanks, that was exactly what was happening.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply