V
Vivian Carroll
DESCRIPTION OF PROBLEM:
I created a "Contractors" database application using Access 2000. It links
to dept.mdw. I have a Contractor Query form where the user types in what to
search by (e.g., "ABC Corp"). The procedure takes the user's input, runs the
appropriate query, displays the data in the "Contractors Report" and changes
the label at the top of the report so that it says "Listing of Contractors
with "ABC Corp" in the Name".
All works just fine when only one person is in the database. However, when
two people are in the database, the report displays the correct records but
the title of the report (label at the top of the report) does not change. My
assumption is that Access has some "built-in protection feature" that won't
allow the report design to be modified if more than one user is in the
database.
QUESTION:
How do I get around this problem?
PERMISSIONS:
The "engineers" group that I was testing this with has these permissions for
that report: Open/Run, Read Design, and Modify Design. (Adding "Administer"
didn't help. The last 4 choices are grayed out: Read Data, Update Data,
Insert Data, and Delete Data.) (I tried making the code create a copy of
the "Contractors Report" and modify that, but the same problem still
happens-the label on the report copy does not get changed.)
Under Tools, Options, Advanced tab, "Default Record Locking" = "No Locks"
and below the following is checked "Open databases using record-level
locking."
TIA,
Vivian Carroll
I created a "Contractors" database application using Access 2000. It links
to dept.mdw. I have a Contractor Query form where the user types in what to
search by (e.g., "ABC Corp"). The procedure takes the user's input, runs the
appropriate query, displays the data in the "Contractors Report" and changes
the label at the top of the report so that it says "Listing of Contractors
with "ABC Corp" in the Name".
All works just fine when only one person is in the database. However, when
two people are in the database, the report displays the correct records but
the title of the report (label at the top of the report) does not change. My
assumption is that Access has some "built-in protection feature" that won't
allow the report design to be modified if more than one user is in the
database.
QUESTION:
How do I get around this problem?
PERMISSIONS:
The "engineers" group that I was testing this with has these permissions for
that report: Open/Run, Read Design, and Modify Design. (Adding "Administer"
didn't help. The last 4 choices are grayed out: Read Data, Update Data,
Insert Data, and Delete Data.) (I tried making the code create a copy of
the "Contractors Report" and modify that, but the same problem still
happens-the label on the report copy does not get changed.)
Under Tools, Options, Advanced tab, "Default Record Locking" = "No Locks"
and below the following is checked "Open databases using record-level
locking."
TIA,
Vivian Carroll