Make Table Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a Make Table Query that will be amended daily via an Append
Query and it needs to allow concurrent users to modify it as well. It will be
serving as a "dispatch list" for a group of four office people. Once run,
they will then go in and "sign on" a job by noting their initials in a
pre-established column. It needs to remain "live" and I am worried about
conflicts when saving (like Excel Shared Files) after two concurrent users
sign out a job (whether it be the same one simultaneously or two different
ones).

As an alternative, could the first one in get "write authority" while others
would get "read only" and be shown who's in it? They all sit within 15 feet
of each other and would only need to "lock it up" for 30 seconds or so to
find which job to work next.

Any thoughts or comments would truly appreciated, thank you.

Regards,
Mike
 
I need to create a Make Table Query that will be amended daily via an Append
Query and it needs to allow concurrent users to modify it as well. It will be
serving as a "dispatch list" for a group of four office people. Once run,
they will then go in and "sign on" a job by noting their initials in a
pre-established column. It needs to remain "live" and I am worried about
conflicts when saving (like Excel Shared Files) after two concurrent users
sign out a job (whether it be the same one simultaneously or two different
ones).
Click to expand...


Why make a table?

You need to have a dispatch list available on a Form or printed out.

If you assume that you must have a Table to do so, your assumption is
in error. You can use a Query selecting those records which are
"live". The query will be updated minute to minute based on other
users' updates.
As an alternative, could the first one in get "write authority" while others
would get "read only" and be shown who's in it? They all sit within 15 feet
of each other and would only need to "lock it up" for 30 seconds or so to
find which job to work next.
Click to expand...

Access is multiuser out of the box. It does NOT have the problems that
you mention regarding Excel Shared Files; multiple users can be
updating the same table concurrently, with very little conflict if you
have proper design. You can't have two people updating the same RECORD
at the same time (but then you wouldn't want to in this case!); the
error that occurs if a second user tries to update a record that
another user has open can be trapped to give them a graceful error
message if you wish.
Any thoughts or comments would truly appreciated, thank you.
Click to expand...

I've written a dispatching application for a very large animal
shelter; it has up to eight busy dispatchers entering and processing
calls simultaneously, moving them from "Open" to "Dispatched" to
"Closed" as appropriate. For their convenience I have a continous Form
displaying all open calls, with a command button on each row to bring
up the data entry form for that call.

John W. Vinson[MVP]
 
John,

Thank you for responding to my post. I am glad you were able to assist the
animal shelter; however, in all honesty, you provided no true guidance for me
to go on. Pointing out that my initial thought of a Make Table was an "error"
and that a form would suffice is barely the tip of the iceberg.

I have never created a Form like the one you're implying. Can you give me a
link to an example and I'll wing it from there.

Regards,
Mike
 
John,

Thank you for responding to my post. I am glad you were able to assist the
animal shelter; however, in all honesty, you provided no true guidance for me
to go on. Pointing out that my initial thought of a Make Table was an "error"
and that a form would suffice is barely the tip of the iceberg.

I have never created a Form like the one you're implying. Can you give me a
link to an example and I'll wing it from there.
Click to expand...

I apologize, Mike. That wasn't very helpful, I agree, and I'm sorry.

However, the form took me a good many hours to design. It's a good bit
more than can be explained in just a simple newsgroup posting.

If you would like a demo copy of the PawTrax application I'll be glad
to send one, but it would really be overkill for this requirement!


John W. Vinson[MVP]
 
Mike, what John is saying is that you create a query containing the names of
the users, from the query tab chose new you could use the wizard or create
the query in design mode, designate the fields in the query either based on
pre existing named fields in your table, or uniquely name them like Lname
Fname, then go to the form you wish to input the data from and in the design
view tool bar press drop down it will prompt you do you wish to use existing
query or type your own values. chose queries, find the one you created and
bingo you have a drop down with the values you assigned.
 
Back
Top