anyone willing to coding in MS-Access for me?

[Guest_imported]

I hope to coding for MS-Access, hope everybody help me!
i hope to have two type of user:

1. they can fully access the databse(MS-Access).

2. they can view the data only. (read-only).when enter the password, pop up 'this is read-only file'

when access this database on the first time, let the user to confirm the password.

later, when start access this database, they'll only appear one password line to enter, then this compiled-file will automatically recognize this is 'host' password or 'viewer' password.

 

[tedsmith]

Visual Basic can handle this easily by changing the type of recordset (snapshot or dynaset) if you are using code only or the properties if you are using datagrids.
To disable the password, you need to have a small table that stores whether it is OK or not and read it when you start up the program.