Hi,
how can i lock my tables, so whenever a user wants to views the records or edit the structure of the table, he/she will be prompted to enter a password.
There are a couple of things that you can look into. Security...see the following from our friends at Microsoft: Security
And you need to create forms for your users to view the data. These can be password protected, or by applying security levels you can keep control of users who have read-only access vs. read and write access.
