Problem: mssql locks several records in a specific table, while no one is editing them

[Oren]

Hi,
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 renedred inert .

Thanks for reading,
Oren.

[John Bell]

Re: Problem: mssql locks several records in a specific table, while no one is editing them

Hi

I can't say that I am an expert on access, but this sounds like the
recordset may need refreshing i.e someone has changed the record and access
knows the local copy is out of date.

John

"Oren" <orentini@hotma il.com> wrote in message
news:b1368c93.0 409160909.128ba e81@posting.goo gle.com...[color=blue]
> Hi,
> 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 renedred inert .
>
> Thanks for reading,
> Oren.[/color]

[Oren]

Re: Problem: mssql locks several records in a specific table, while no one is editing them

Hi,
thanks for replying.

There is no local and remote copy of the table, the table is only
stored in the sql server and linked to the access MDB.

Simple refresh wont do (tried it, via the access menubars).

have any more suggestions?

Thanks,

Oren,



"John Bell" <jbellnewsposts @hotmail.com> wrote in message news:<414b53f6$ 0$27296$afc38c8 7@news.easynet. co.uk>...[color=blue]
> Hi
>
> I can't say that I am an expert on access, but this sounds like the
> recordset may need refreshing i.e someone has changed the record and access
> knows the local copy is out of date.
>
> John
>
> "Oren" <orentini@hotma il.com> wrote in message
> news:b1368c93.0 409160909.128ba e81@posting.goo gle.com...[color=green]
> > Hi,
> > 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 renedred inert .
> >
> > Thanks for reading,
> > Oren.[/color][/color]

[John Bell]

Re: Problem: mssql locks several records in a specific table, while no one is editing them

Hi

You may want to post this is an access news group!

John

"Oren" <orentini@hotma il.com> wrote in message
news:b1368c93.0 409180015.71846 5e6@posting.goo gle.com...[color=blue]
> Hi,
> thanks for replying.
>
> There is no local and remote copy of the table, the table is only
> stored in the sql server and linked to the access MDB.
>
> Simple refresh wont do (tried it, via the access menubars).
>
> have any more suggestions?
>
> Thanks,
>
> Oren,
>
>
>
> "John Bell" <jbellnewsposts @hotmail.com> wrote in message[/color]
news:<414b53f6$ 0$27296$afc38c8 7@news.easynet. co.uk>...[color=blue][color=green]
> > Hi
> >
> > I can't say that I am an expert on access, but this sounds like the
> > recordset may need refreshing i.e someone has changed the record and[/color][/color]
access[color=blue][color=green]
> > knows the local copy is out of date.
> >
> > John
> >
> > "Oren" <orentini@hotma il.com> wrote in message
> > news:b1368c93.0 409160909.128ba e81@posting.goo gle.com...[color=darkred]
> > > Hi,
> > > 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 renedred inert .
> > >
> > > Thanks for reading,
> > > Oren.[/color][/color][/color]