Link to second form for read-only users? Possible????

  • Thread starter Thread starter ReadReadWrite
  • Start date Start date
R

ReadReadWrite

We have a lawfirm library catalog in Access and we want to make it available
to the attorneys here, so I created another form (changing the properties so
that it does not allow editing) for the same table. How can I link to this
second form? From other Access forms I can hyperlink directly to the second
form, but every other way I can find to create a hyperlink or shortcut, I can
only choose the database, which defaults to the original form. I would like
to link directly to the new form for the attorneys from a posted Word
document, and keep using the original form myself. Currently I can get to
the second form only by opening the database which defaults to the original
form, closing the original form and then choosing the second form.
I don't think the attorneys would have any patience trying to use a Data
Access Page, and I find them to be alien and overwhelming myself (where the
heck is the binoculars search icon?).
 
Hi RRW,

This may not be the best way, but you COULD make a separate front end for
the lawyers (assuming your file is split). You could import the second form,
link the tables from the back end, and make the second form the one that
opens when the database opens.

CW
 
Although I don't think anything is "split," I've created a new database (new
front end?), imported the second form, and linked a table there to the
catalog table. I was then able to hyperlink from Word. Great so far. But
when you click from the hyperlink you get the new database menu (Tables,
Queries, Forms, etc.). Nothing opens! Attorneys wouldn't know what to do
from this point. How can I make the form open on opening the database?
 
Hi RRW,

Glad you got it working!

CW

PS: You might want to do a google on splitting an MS Access database. There
are some significant advantages to doing it, particularly if you have
multiple users.
 
Back
Top