In use by another..?

[Kujen]

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 has a primary key defined.
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,
[FtgLänk] [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.

 

[dhookom]

Try change the bit field to tiny int or set its default to 0.

Duane
Hook'D on Access
MS Access MVP

 

[Kujen]

dhookom,

I figured it out!
[bit] NOT NULL,
..if it's null and you try to edit you'll get: "Edited by another user".

Kent J.

 

[dhookom]

That's the problem. I avoid all bit fields in Access and SQL Server.

Your code looks like you are building a spreadsheet rather than a relational database. I assume you understand your project better than I do.

Duane
Hook'D on Access
MS Access MVP