| re: Access 2k locks some records with no apperant reason
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]
| 
