locking down tables

[john_szakiel]

I'm realtively new at this and was wondering if the following is
possible relatively simply.

I have a databse with many tables (most linked via relationships - some
not). Most tables live in the back end of the database on a network
with the front end rresiding on one or more desktops.

When bank reporting is being done for the day - I want the perosn doing
this to be able to lock all tables from being updated and perhaps
throwing a message up to alert users that the daily reporting is
underway an updates are locked out for the moment.

Am I getting too ambitious?

[MacDermott]

The simple approach would be to set the RecordLocks property of each report
to "All Records" (instead of the default "No Records").
Of course, if you're running a series of reports, this won't prevent users
from changing data between reports, but it's a start.
<jo**********@medibank.com.au> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

I'm realtively new at this and was wondering if the following is
possible relatively simply.

I have a databse with many tables (most linked via relationships - some
not). Most tables live in the back end of the database on a network
with the front end rresiding on one or more desktops.

When bank reporting is being done for the day - I want the perosn doing
this to be able to lock all tables from being updated and perhaps
throwing a message up to alert users that the daily reporting is
underway an updates are locked out for the moment.

Am I getting too ambitious?

[john_szakiel]

MacDermott wrote:

The simple approach would be to set the RecordLocks property of each report
to "All Records" (instead of the default "No Records").
Of course, if you're running a series of reports, this won't prevent users
from changing data between reports, but it's a start.
<jo**********@medibank.com.au> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

I'm realtively new at this and was wondering if the following is
possible relatively simply.

I have a databse with many tables (most linked via relationships - some
not). Most tables live in the back end of the database on a network
with the front end rresiding on one or more desktops.

When bank reporting is being done for the day - I want the perosn doing
this to be able to lock all tables from being updated and perhaps
throwing a message up to alert users that the daily reporting is
underway an updates are locked out for the moment.

Am I getting too ambitious?

[john_szakiel]

Kewl - thanks for that - I have an idea on how I might be able to get
access to wait until all reports are finished