Question How to password-protect my vb codes?

[shieriel]

Hello everyone. May i ask is it possible to protect the codes by a password? And if possible how can i do that...

 

[SOS]

Yes, you can and you go into the VBA window and then to the Object Explorer and right click on the project name and select the <the project name> PROPERTIES and then click on the PROTECTION tab. The rest should be self-explanatory.

 

[pbaldy]

It is probably most common to distribute an mde/accde to users, which will not allow them to view code or change the design of forms and reports. You can set a password, but I never have. It's in Tools/DatabaseName Properties/Protection tab.

 

[pbaldy]

Slllooooowwwww fingers.

 

[shieriel]

It is probably most common to distribute an mde/accde to users, which will not allow them to view code or change the design of forms and reports. You can set a password, but I never have. It's in Tools/DatabaseName Properties/Protection tab.

HI, how can i distribute an mde or accde? How can i do that? Sorry i am just a beginner in access

 

[georgedwilkinson]

The same way you distribute an MDB file: you give the MDE or ACCDE file to the user to begin using with Access (just like you would with a Word or Excel file, for instance).

I recommend you do a lot of studying about the ramifications of maintaining a system that you've distributed as an MDE/ACCDE. You'd think it would be pretty straight-forward, but there are some gotchas.

 

[pbaldy]

HI, how can i distribute an mde or accde? How can i do that? Sorry i am just a beginner in access

Start by looking in help at mde (versions prior to 2007) or accde (2007). Post back if you have questions.

 

[shieriel]

Start by looking in help at mde (versions prior to 2007) or accde (2007). Post back if you have questions.

HI. I am using access2003 format and i cannot convert it into mde file. Please see attached picture for the error...

 

[HiTechCoach]

to make an mde the database must be able to compile without errors.

Manually compile the code to see if there are any errors. Fix the error. Repeat until it compiles without error.

 

[shieriel]

to make an mde the database must be able to compile without errors.

Manually compile the code to see if there are any errors. Fix the error. Repeat until it compiles without error.

I am sorry but i dont know how to "compile the code"

 

[HiTechCoach]

Open the VBA editor (Alt-F11). On the menu Debug > Compile

 

[shieriel]

Open the VBA editor (Alt-F11). On the menu Debug > Compile

Hi, i succesfully convert my database into mde file. But what if i want to edit some codes? How can i open again with the "Edit Program" open? Thanks..

 

[pbaldy]

You keep the mdb to make changes to, then you create a new mde and distribute it to users. There are tools to automate that if needed.

 

[shieriel]

You keep the mdb to make changes to, then you create a new mde and distribute it to users. There are tools to automate that if needed.

Thanks! May i ask what are those automation tools?

 

[pbaldy]

Here's one:

http://autofeupdater.com/

 

[shieriel]

Here's one:

http://autofeupdater.com/

Thanks so much!