What is the problem do you see on the above solution?

Basically On UI screen, if user select any case(Radio Button) for modication and start any modification that particualt case needs to be locked for other user.

That's why I want to...

4 Logical Processor.

2 Logical Processor's load are low compare to other 2

Thanks for the reply.

I read somewhere in the docs/forms, "lightweight pooling" implementations and requirements should

be analyzed by Microsoft first.

Is this juts a tuning configurable item which we can start...

Hi,

Did you find a solution of this issue?

I am facing a similar issue while readaing a different row from the table.

What is happening:

First Connection:

1. insert 4 new rows.

2. update one...

yeah using this only...I came to know about the KEY locks using this command.

In later analysis I found, as soon as rs.next (with 0 row) executes it creates a new...

In the first connection UPDATE and DELETE are firing with Primary key, even for single only and creating a KEY lock only. for insert also ...I know any new...

Thanks for the reply.

In second connection which is getting fire a select stmnt, actually firing with diffrent key set.

not the same which is blocked by first connection using the update/delete/insert.

and...

Yes,

We need to deliver the 360 tables data into the one access mdb file.

We used to do the same successfully in SQL Server 2000 using the DTS, but now...

my mistake...it is 360 tables.....

Error Msg :

"A large no of tables are selected for copying, and the wizard may not be able to copy all the tables in a session.select NO to go back...

Thanks for the reply.

But the link you provided is not opening the page, you asked.Could you please check the link and

send me again if any error on it.

Thanks again!