Hi All,

I have a Access front-end,the tables are from SQL server 2000 and
linked via ODBC using DSN.
I have a Main table and several related tables.The Main table has a
One -to- Many relationship with the related tables.
When I try to delete a record from the front-end,I get a error msg "
the table is locked,you and another user are attempting to delete/
update the same record".I am the single user and I am at a loss to
understand what the problem is.

I have to explain that I never had a problem when i was using Access
as the backend too.Is it because of linking?

Any suggestions?

Roy

Are you are running the sql statement from Access?
Is the DSN a User DSN or System DSN?

--

Jack Vamvas
___________________________________
The latest IT jobs - www.ITjobfeed.com
<a href="http://www.itjobfeed.com">UK IT Jobs</a>


"Roy" <praish1998 (AT) yahoo (DOT) com> wrote

Jack Vamvas wrote:

What SQL statements does Profiler show as being attempted?
How are the relationships enforced (which ON DELETE option is in use)?