I've got a system made up of a SQL 2005 backend and an Access front-end. The front-end only holds the linked tables (plus the code).
Whenever I try to delete a record IN Access (directly in the table itself), Access throws an error, so I have to go to the back-end and delete it manually. I guess the problem is with the definition of the table in SQL, but I can't find what's wrong with it. Some other tables in the back-end look similar but you can delete records normally.
CREATE script attached:
/****** Object: Table [dbo].[tblPAScores] Script Date: 04/05/2013 17:22:41 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
CREATE TABLE [dbo].[tblPAScores](
[VolunteerID] [varchar](50) NOT NULL,
[NoWeek] [int] NULL,
[PA] [numeric](5, 2) NULL,
[Class] [varchar](50) NULL,
[NoPeople] [int] NULL,
[Entered] [datetime] NULL,
[Notes] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
SET ANSI_PADDING OFF
Any advice on other improvements very welcome. Thanks in advance, a.