Tables in multiuser environments

[Bill Mitchell]

Hi,

I have some code that creates a query. Question is, in a
multiuser environment, every time a different user runs
that code, does it change the query for everyone? If so,
that would be a problem.

Also, if I have a query that is a "make-table" and a
second user runs the same query 1 minute after I run it,
does it overwrite the table my query created?

Sorry, but I dont understand the multi-user thing very
well.

 

[StCyrM]

Hi Bill

Are you using a Front End/Backend configuration?

If you you should not be having this problem.

Maurice

 

[Albert D. Kallal]

You can split the database into two parts, and this will enuser that each
user will create, or have their "own" query.

In fact, for anytime you setup ms-access for multi-user, you should split
the database into two parts.

Here is some good reading on this:

http://www.granite.ab.ca/access/splitapp.htm

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm