In use by another user..?

Hi all,
I have a liked SQL-server 2000 table in an Access database.
This table have worked fine for 6 months.
But now it start to say: 'In use by another user..' when I try to edit a
record. The table looks like this:
=====================================
CREATE TABLE [dbo].[Tbl_IS_Flagga](
[Orgnr] [nvarchar](11) NOT NULL,
[Flagga1] [bit] NOT NULL,
[Flagga1Ben] [nvarchar](max) NULL,
[Flagga2] [bit] NOT NULL,
[Flagga2Ben] [nvarchar](max) NULL,
[Flagga3] [bit] NOT NULL,
[Flagga3Ben] [nvarchar](max) NULL,
[FtgBeskrivning] [nvarchar](max) NULL,
[FtgLnk] [nvarchar](max) NULL
) ON [PRIMARY]
======================================
It seems to me that the problems are related to the records in the
table. What can I do about it?
Kent J.
My guess is that Access is acting up for any of below reasons:
The primary key for the table was removed.
Someone created a trigger on the table,. which does some strange things (like returning "rows
affected" messages).
Only guesses...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kent J" <kent.johnson@.telia.com> wrote in message news:5LtLj.5924$R_4.4639@.newsb.telia.net...
> Hi all,
> I have a liked SQL-server 2000 table in an Access database.
> This table have worked fine for 6 months.
> But now it start to say: 'In use by another user..' when I try to edit a record. The table looks
> like this:
> =====================================
> CREATE TABLE [dbo].[Tbl_IS_Flagga](
> [Orgnr] [nvarchar](11) NOT NULL,
> [Flagga1] [bit] NOT NULL,
> [Flagga1Ben] [nvarchar](max) NULL,
> [Flagga2] [bit] NOT NULL,
> [Flagga2Ben] [nvarchar](max) NULL,
> [Flagga3] [bit] NOT NULL,
> [Flagga3Ben] [nvarchar](max) NULL,
> [FtgBeskrivning] [nvarchar](max) NULL,
> [FtgLnk] [nvarchar](max) NULL
> ) ON [PRIMARY]
> ======================================
> It seems to me that the problems are related to the records in the table. What can I do about it?
> Kent J.
|||What about locks or transaction log?
If I create new table with 'old' and new records then I have problem
with the old ones but not with the new records. Strange!
Kent J.
Tibor Karaszi skrev:
> My guess is that Access is acting up for any of below reasons:
> The primary key for the table was removed.
> Someone created a trigger on the table,. which does some strange things
> (like returning "rows affected" messages).
> Only guesses...
>
|||Have you tried to "edit a record" using an UPDATE statement in a query
window?
Why does the table not have a key? How do you identify a single row?
"Kent J" <kent.johnson@.telia.com> wrote in message
news:5LtLj.5924$R_4.4639@.newsb.telia.net...
> Hi all,
> I have a liked SQL-server 2000 table in an Access database.
> This table have worked fine for 6 months.
> But now it start to say: 'In use by another user..' when I try to edit a
> record. The table looks like this:
> =====================================
> CREATE TABLE [dbo].[Tbl_IS_Flagga](
> [Orgnr] [nvarchar](11) NOT NULL,
> [Flagga1] [bit] NOT NULL,
> [Flagga1Ben] [nvarchar](max) NULL,
> [Flagga2] [bit] NOT NULL,
> [Flagga2Ben] [nvarchar](max) NULL,
> [Flagga3] [bit] NOT NULL,
> [Flagga3Ben] [nvarchar](max) NULL,
> [FtgBeskrivning] [nvarchar](max) NULL,
> [FtgLnk] [nvarchar](max) NULL
> ) ON [PRIMARY]
> ======================================
> It seems to me that the problems are related to the records in the table.
> What can I do about it?
> Kent J.
|||Yes, I can use UPDATE instead.
I have primary key on the first field.
CONSTRAINT [PK_Tbl_IS_Flagga] PRIMARY KEY CLUSTERED
(
[Orgnr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
Aaron Bertrand [SQL Server MVP] skrev:
> Have you tried to "edit a record" using an UPDATE statement in a query
> window?
> Why does the table not have a key? How do you identify a single row?
>
> "Kent J" <kent.johnson@.telia.com> wrote in message
> news:5LtLj.5924$R_4.4639@.newsb.telia.net...
>
|||Hi all,
I figured it out!
[bit] NOT NULL,
...if it's null and you're trying to edit you'll get: "Edited by another
user".
Kent J.
Kent J skrev:
> Hi all,
> I have a liked SQL-server 2000 table in an Access database.
> This table have worked fine for 6 months.
> But now it start to say: 'In use by another user..' when I try to edit a
> record. The table looks like this:
> =====================================
> CREATE TABLE [dbo].[Tbl_IS_Flagga](
> [Orgnr] [nvarchar](11) NOT NULL,
> [Flagga1] [bit] NOT NULL,
> [Flagga1Ben] [nvarchar](max) NULL,
> [Flagga2] [bit] NOT NULL,
> [Flagga2Ben] [nvarchar](max) NULL,
> [Flagga3] [bit] NOT NULL,
> [Flagga3Ben] [nvarchar](max) NULL,
> [FtgBeskrivning] [nvarchar](max) NULL,
> [FtgLnk] [nvarchar](max) NULL
> ) ON [PRIMARY]
> ======================================
> It seems to me that the problems are related to the records in the
> table. What can I do about it?
> Kent J.