read-only refresh

[mattbland]

the database i am producing will be constantly updated - but a 2nd terminal in a warehouse needs the info in the database for their work - they wont be allowed to modify the data just read what is says - how can this data be updated with two copies opened at the same time??

 

[Fizzio]

Easiest way is to split the Db into Frontend and Backend. Create 2 copies of the frontend - one that allows edits on forms etc, one that doesn't
Another way is by using security. I'm not sure if Access security allows this fine control of data entry or not but you can implement your own security and check the user permissions on opening of a form and set the allow edits/deletions etc from code.

Someone may be able to answer the access security issue though.
HTH