Multi user Report

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

Guest

I need to generate a report that contains data from 2 sources: access table
and ODBC linked table from AS400. The fields are not exactly the same, so I
created 2 subreports, one for each source, then connect them together with a
header record. I create the header record table every time they click the
button to preview. It's working OK.

The problem is if there's more than 1 user are trying to view the report it
doesn't work. Since the first user is using the header table and the user
following the first can't recreate the table. Then I thought if I have a
temp table for each user for this purpose it might work. I did that, but is
still not working because in order for the report to use the tmp table I
needed to change the record source of the report, which in turn locks the
report. I'm sorry this is so long. Any suggestions?
 
You should consider creating your applications with a separate front-end for
each user and a single, shared back-end on the network. This eliminates a
number of problems.
 
Hi Duane,
It is actually already split, but the users are using a terminal server
to access the front end.
 
I am not familiar with work-arounds using terminal server. I guess I would
add a field to the temporary table that identifies the user and then limit
the report to the specific user.
 
Duane,

Thank you for bringing to my attention about splitting the database. I
figured it out. The users were opening the version on the server instead of
a copy that's on their desktop. It's working fine now that I ask them to
open the front end copy that's on their desk top.

Thank you again..
 
Back
Top