load-up form in access

[sagat]

Hi all, how do i create a load-up form in access. i.e when a user clicks on the access file, a form loads automatically. And how do i make an access file non-editable (read-only)? thanks

[johnjohn2]

If you go to the "tools" menu, there should be an entry there called "startup". You can select whatever form you want to auto open when the database opens.

For making it read only you have a few options. Go to Tools menu, security, decrypt/encrypt
or
Tools, Database Utilities, Make MDE file. (This way your uses couldn't see most of your code)
or
If the file is on an NT based machine just set the file permissions to read only.

Before you play with some of the features though, you better make a backup. The MDE option strips out and compiles all the editable code and is non reversible.

[sagat]

thanks will do