thanks

all that advice helped and database is now running fine

Hi Peter Larsson.

Thanks for your reply.

I have already tried this but the problen that i face is that. when there are more than 1 clients accessing the database.

for example.

1st person...

Hi Peter Larsson.

Thanks for your reply.

The query you have submitted does the same thing as of  i had submitted, but the probles is that i want the result in a...