Posted by Jack Vamvas on 03/06/07 08:50

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@yahoo.com> wrote in message
news:1173148692.840874.72780@c51g2000cwc.googlegroups.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
>

• Next in forum: Re: Merge Replication Error: 'Failure to connect to SQL Server with provided connection
• Prev in forum: Identity range managed by replication is full and must be updated by a replication agent. Error Message Makes NO SENSE.
• Thread view: Re: Delete and update

[Reply to this message]