Access 2k locks some records with no apperant reason

Hi,
I've posted this message over at the ms-sql newsgroup – no luck.
Maybe some one here could help.


I have an Access application with linked tables via ODBC to MSSQL
Server 2000.

Having a weird problem, probably something I've done while not being
aware of (kinda newbie).

the last 20 records (and growing)of a specific table are locked - cant
change them - ("another user is editing these records ... ").

I know for a fact that no one is editing records and yet no user can
edit these last records in the MDB - including the administrator -
while able to add new records.

Administrator able to edit records in the ADP (mssql server) where the
tables are stored.

Please help, the application is rendered inert.

Thanks for reading,
Oren

Just a guess -
but have you tried deleting and re-creating the link?
compacting the mdb?

- Turtle

"Oren" <orentini@hotmail.com> wrote in message
news:b1368c93.0409190816.77324796@posting.google.c om...[color=blue]
> Hi,
> I've posted this message over at the ms-sql newsgroup - no luck.
> Maybe some one here could help.
>
>
> I have an Access application with linked tables via ODBC to MSSQL
> Server 2000.
>
> Having a weird problem, probably something I've done while not being
> aware of (kinda newbie).
>
> the last 20 records (and growing)of a specific table are locked - cant
> change them - ("another user is editing these records ... ").
>
> I know for a fact that no one is editing records and yet no user can
> edit these last records in the MDB - including the administrator -
> while able to add new records.
>
> Administrator able to edit records in the ADP (mssql server) where the
> tables are stored.
>
> Please help, the application is rendered inert.
>
> Thanks for reading,
> Oren[/color]

Turtle,

tried the following:

1. delete/recreate the link
2. delete the original table (ADP) and restoring from a backup, then recreating link
3. compress mdb
4. all kinda fiddling with options witch seem to have to affect now.

Oren.



"MacDermott" <macdermott@nospam.com> wrote in message news:<gIq3d.7077$n16.2526@newsread2.news.atl.earth link.net>...[color=blue]
> Just a guess -
> but have you tried deleting and re-creating the link?
> compacting the mdb?
>
> - Turtle
>
> "Oren" <orentini@hotmail.com> wrote in message
> news:b1368c93.0409190816.77324796@posting.google.c om...[color=green]
> > Hi,
> > I've posted this message over at the ms-sql newsgroup - no luck.
> > Maybe some one here could help.
> >
> >
> > I have an Access application with linked tables via ODBC to MSSQL
> > Server 2000.
> >
> > Having a weird problem, probably something I've done while not being
> > aware of (kinda newbie).
> >
> > the last 20 records (and growing)of a specific table are locked - cant
> > change them - ("another user is editing these records ... ").
> >
> > I know for a fact that no one is editing records and yet no user can
> > edit these last records in the MDB - including the administrator -
> > while able to add new records.
> >
> > Administrator able to edit records in the ADP (mssql server) where the
> > tables are stored.
> >
> > Please help, the application is rendered inert.
> >
> > Thanks for reading,
> > Oren[/color][/color]

Turtle,

tried the following:

1. delete/recreate the link
2. delete the original table (ADP) and restoring from a backup, then recreating link
3. compress mdb
4. all kinda fiddling with options which seem to have to affect now.

Oren.



"MacDermott" <macdermott@nospam.com> wrote in message news:<gIq3d.7077$n16.2526@newsread2.news.atl.earth link.net>...[color=blue]
> Just a guess -
> but have you tried deleting and re-creating the link?
> compacting the mdb?
>
> - Turtle
>
> "Oren" <orentini@hotmail.com> wrote in message
> news:b1368c93.0409190816.77324796@posting.google.c om...[color=green]
> > Hi,
> > I've posted this message over at the ms-sql newsgroup - no luck.
> > Maybe some one here could help.
> >
> >
> > I have an Access application with linked tables via ODBC to MSSQL
> > Server 2000.
> >
> > Having a weird problem, probably something I've done while not being
> > aware of (kinda newbie).
> >
> > the last 20 records (and growing)of a specific table are locked - cant
> > change them - ("another user is editing these records ... ").
> >
> > I know for a fact that no one is editing records and yet no user can
> > edit these last records in the MDB - including the administrator -
> > while able to add new records.
> >
> > Administrator able to edit records in the ADP (mssql server) where the
> > tables are stored.
> >
> > Please help, the application is rendered inert.
> >
> > Thanks for reading,
> > Oren[/color][/color]