lock records after upload

  • Thread starter Thread starter mon
  • Start date Start date
M

mon

Have to repost this one.
I would like to make records uneditable on the local
database after they have been uploaded to the main
database. There is a logical upload field. thanks, mon
..
 
Have to repost this one.
I would like to make records uneditable on the local
database after they have been uploaded to the main
database. There is a logical upload field. thanks, mon
.
Click to expand...

How are you "uploading"? From where are you uploading? Where and what
is the "logical upload field"?

You can certainly apply Access Security to your database, and prohibit
users from updating the tables; the program which does update the
tables could be run from an account with updates allowed.
 
I have data enter databases on laptops for users to enter
their activities. When they exit the program the records
(which have the "sent" field false) are sent to an excel
table to be emailed to me to load on to the main database;
on sending, the Sent field is changed to true. I would
like to ensure that the records on the laptops cannot be
changed after being sent. Sorry, is that clearer? Thanks
Mon
 
Back
Top