Hello all. Read some of the previous posts that skirted the same issue
but they mostly involved backing up or compressing. I have 5 service
type databases (ie. ser83-88, ser89-92, ser92-95, etc.) I want to make
each of these databases READ ONLY so if I need to go back and view a
record within them I cannot accidently change the data in any of the
fields. This way I can insure the integrity of the data. I am the only
one using this database and it is on a stand alone PC not a network so
that is not an issue. I am looking for a simple way of doing this. I
read about scripts and have NO idea how or what they are so if we can
accomplish this without them that would be o.k. Thanks and any help
provided would be appreciated.

I had one database that I and my assistant used for recording daily
sales from our POS. All numbers were change-able during the month.
There was one record by DATE. We used a script to find by DATE. If
the record had yet to be recorded, it presented a blank record. If
the record was there it presented the record.

We had until the third of the month to balance the month. The script
to Add or View a day would compare the date requested, it if was in a
prior month (past the 3rd day) it went to a layout with fields that
were not accessible. EndUsers could not go to layouts directly, but
only by script. The only way I could was through LAYOUT mode then
back to BROWSE mode.

Questions to ask yourself is at what point do the record become read-
only? You could use an Add Record script that uses globals to enter
day that is posted to the database in the background. But the only
layouts you give yourself are read-only.

Thomas

On Apr 10, 11:42 am, "speedracer" <sjmorris2... (AT) yahoo (DOT) com> wrote:

In article <1176223378.020138.262570 (AT) w1g2000hsg (DOT) googlegroups.com>,
"speedracer" <sjmorris2001 (AT) yahoo (DOT) com> wrote:

A couple of ways you might think about:

1. Create a read-only user account, and only open the database using
that read-only account. For details on doing this, see the Help file, in
the section on Protecting Databases with Accounts and Privilege Sets.

2. Create a layout that displays the fields you want to view, and in the
Layout mode set all the fields to be not entered in the browse mode. Do
do that, select the fields in the Layout mode then set up the behavior
using the menu
Format >> Field Control >> Behavior and uncheck the box "Allow field to
be entered in Browse mode"

--
For email, change <fake> to <earthlink>
Bill Collins