multi-user on one shared databae

R

Rover

I've created a form that runs some queries and creates a table and a
report from that table. The end users have put my db on a server for
use by multiple users at the same time (not high volume - maybe 3 or 4
people). BUT the problem is that table I create now could be corrupted
as multiple users could be trying to create that table at the same time.

I don't like the way they've set this up but I'm stuck with it.

How do I create this table so people aren't stepping on each other.
I'll confess that I don't do multi-user programming.

Jim
 
R

Rover

Yes - that's the correct solution - but that's not an option at this
time. I've got one db for all users on one server.
 
A

Allen Browne

Then you are stuck until you can convince whoever made that policy that they
are responsible for all the failures that will ensure.

Personally, I would walk away from a client like that, and tell them to call
me when they had changed their mind.
 
R

Rover

I'm told all the users have Citrix thin-client machines that forces the
db to be on the server...
 
A

Allen Browne

That's not a problem.

Just place a separate copy of the MDE front end into each user's space on
the server. Each user is then executing a separate copy of the application
in their session.

The fact that these sessions are actually executing on the server is a very
good approach if the network is a WAN. More info about that:
http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html
 
Top