Message says another user accessing data

[Mark A. Sam]

My Access database as link SQL Server tables. I am trying to remove records
from a subtable and getting this message:

The Microsoft Jet database engine stopped the process becuase you or another
user are attempting to change the same data at the same time.

This isn't the case, however. No one else is on the Database ( I have a
tool which displays the users) and if they were, I am working with test
records which noone would have an interest in viewing.

This happened on a table before, but cleared up when I shut down the
database and opened it again. Now I can't delete the records.

Any help is appreciated.

God Bless,

Mark A. Sam

 

[Rick Brandt]

My Access database as link SQL Server tables. I am trying to remove
records from a subtable and getting this message:

The Microsoft Jet database engine stopped the process becuase you or
another user are attempting to change the same data at the same time.

This isn't the case, however. No one else is on the Database ( I
have a tool which displays the users) and if they were, I am working
with test records which noone would have an interest in viewing.

This happened on a table before, but cleared up when I shut down the
database and opened it again. Now I can't delete the records.

Any help is appreciated.

Add a Timestamp column to the table on the server and make sure any bit fields
do not allow Nulls. Links below explain reasons for this to occur.

http://support.microsoft.com/default.aspx?scid=kb;en-us;96897
http://support.microsoft.com/default.aspx?scid=kb;en-us;280730

 

[Mark A. Sam]

Rick,

The table had a time stamp, but a bit filed I just added was allowing nulls.
When I unchecked and tried to save I got this error:

'Customer ST Products Tasks' table
- Unable to modify table.
ADO error: Cannot insert the value NULL into column 'TestRecord', table
'STSIData.dbo.Tmp_Customer ST Products Tasks'; column does not allow nulls.
INSERT fails.
The statement has been terminated.


I don't know what this means since it was checked to allow nulls.

I am working remotely through terminal services and don't have the use of
Project Manager, so I set up a project in Access 2000 to modify the tables.
That could be the problem, I don't know. I tried removing the field and
reentering it, unchecking the 'AllowNulls' checkbox with the same problem.

God Bless,

Mark

 

[Guest]

You have to ensure all your bit fields have either a TRUE (1) or FALSE (0)
Value and NO NULL value.

The reason is, several of the records in your table have null values... when
you try to modify the design so that it does not allow nulls, it cant modify
it because there already are nulls in the table in some records.

Try running an update query on that table that converts all NULLS on the
field into 0 "UPDATE tablename set fieldname = 0 where fieldname is null"
then try to modify your table Again

 

[Mark A. Sam]

There aren't any Null values. In fact I am able to delete new records, but
there is a batch that I am unable to remove. When I added the Field, the
system entered 0 to the existing records.

 

[Mark A. Sam]

Well this clear up for no apparent reason other than prayer.