Delete and update

[Roy]

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

[Jack Vamvas]

Re: Delete and update

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.c om">UK IT Jobs</a>


"Roy" <praish1998@yah oo.comwrote in message
news:1173148692 .840874.72780@c 51g2000cwc.goog legroups.com...

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
>

[Ed Murphy]

Re: Delete and update

Jack Vamvas wrote:

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

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