By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,779 Members | 1,291 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,779 IT Pros & Developers. It's quick & easy.

Access 2k locks some records with no apperant reason

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


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

- Turtle

"Oren" <or******@hotmail.com> wrote in message
news:b1**************************@posting.google.c om...
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

Nov 13 '05 #2

P: n/a
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" <ma********@nospam.com> wrote in message news:<gI*****************@newsread2.news.atl.earth link.net>...
Just a guess -
but have you tried deleting and re-creating the link?
compacting the mdb?

- Turtle

"Oren" <or******@hotmail.com> wrote in message
news:b1**************************@posting.google.c om...
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

Nov 13 '05 #3

P: n/a
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" <ma********@nospam.com> wrote in message news:<gI*****************@newsread2.news.atl.earth link.net>...
Just a guess -
but have you tried deleting and re-creating the link?
compacting the mdb?

- Turtle

"Oren" <or******@hotmail.com> wrote in message
news:b1**************************@posting.google.c om...
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

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.