my database is ac2003. i like to restrict its tables so that users can only with userid and password modify'em. also, my program can modify them using only userid and password. How to accomplish this through VB or other ways?.

my database is ac2003. i like to restrict its tables so that users can only with userid and password modify'em. also, my program can modify them using only userid and password. How to accomplish this through VB or other ways?.

Access has the built in ability to do what you want with the User Level Security.

When learning has the security model works, practice on a copy of your database until you completely understand how it works. Make Llots of backups!


See:
Access 2002/2003 Security Step by Step (http://www.jmwild.com/security02.htm)

and

The Microsoft Access Security Apparatus (http://www.grahamwideman.com/gw/tech/access/accesssec/index.htm)

Hope this helps ...