Tables in Multiuser...

[Guest]

Hi,

I've devised a new way to do searches based upon creating filters in sql by
looping through a "Search Table" of parameters.

My only question is, if I have a multiuser environment, will i need a
seperate ID for each user entering parameters into the Search Table?

The way I am using it now, I enter parameters, do the search then clear the
table using a delete query, but it occured to me this might be a problem in
multiuser as others would be using the same table I am to create their own
searches. The ID field for each search record identifying the "creator"
would solve that.

Can someone help me? I've never done multi and I confess I don't really
underatnd its nuances.

 

[Ken Snell [MVP]]

By multiuser, do you mean more than one person using the same database file
at the same time? This is likely to lead to corruption, let alone the
problems that you are seeking to avoid.

Split the database into a back end (data tables only) and a front end
(everything else). Give each person a copy of the front end and put the
back end on a shared network folder. Each person then can use a copy without
problems.

Then, to get around your dilemma, use a table that is in the front end for
the "search" data. Each person will have his/her own table and there'll be
no conflicts.