UPDATE table vs INSERT INTO - increasing security

[Minty]

If your users are using runtime then it's quite difficult (almost impossible) to get to the tables unless you provide a method to do so.
You can't lock a table as such, and wouldn't normally want to. You can query it in a read only fashion to display data.

 

[jaryszek]

Minty, i will test in on my database and i let you know when i will have some results.

After few tests i know that it is possible to have a form with your table in Access Runtime.

Jacek

 

[jaryszek]

Hi Guys,

my new topic connected a little bit with this one is here:

http://www.access-programmers.co.uk/forums/showthread.php?p=1515462#post1515462

Jacek