Access database access and security.
Posted on 2003-03-04
This may seem so easy and logical, I just want to get more opinions on the subject. Its been a while since I've used an Access database for any application.
I want to build an application that many client computers connect to the same Access database (located on a central server). How do I protect the contents of the database assuming people know where the location of the database is? How do I restrict access to the database for authenticated users in the database? I'm just worried about the security issues and what is the optimum security setup for a VB6 application using MS-Access?