multi-user on one shared databae

  • Thread starter Thread starter Rover
  • Start date Start date
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
 
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.
 
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.
 
I'm told all the users have Citrix thin-client machines that forces the
db to be on the server...
 
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
 
Back
Top