Multiple users and lock errors

[CleoMan]

In our system we use reports based on SQL code, which is executed at run time to create invoices for customers.

But a obvious problem has occured and has me somewhat stumped.

When two users are connected to our system through a central server and tries to run a invoice (or any other report for that matter) st the same time a lock error occurs for person A ( on the SQL created table) when the report opens at person B's computer.

The question is then how can I avoid lock errors, becuase our system needs to accomodate more that one user running the program from a server.

 

[CleoMan]

I forgot to add:

There is also for instance a form (form A) that has a table on it. This table is created via SQL that is run from a previous (Form B) that calls Form A after running the SQL.

But now when Form A is open Form B cannot run the SQL becuase Form A's table has locked the SQL table.

I hope this makes sense....

Anyway, just need thoughts and generall ideas about the problem of multiple users.

As always gratefull...

 

[Langley]

The simplest solution would be to change the result table so that it is created in the user's private directory, and have the report point to it there.

Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[CleoMan]

Awesome, that is a pretty good solution, I only wish I thought of it, but at least I learnd something,

Thanks alot

Richard