Protect the VBA Code
how to protect queries and VBA code against stealing
We are designing a database which has several queries and vba codes. We don't want anyone to view the queries or steal them as it is proprietary information.
What is the best way to password protect the queries and VBA codes and still letting the users to use the database.
Access - Open Document / Protect
I'm trying to figure out how to open a Word doc from Access, populate certain fields, then protect the document from editing (just allowing form entry).
All of this is relatively simple, opening the document and populating the fields. The problem comes that you cannot populate the fields in a protected document, therefore, the document must be unprotected.
Then, because the control has passed to Word, I cannot figure out how to protect the form from my Access VBA code.
Make your own CODE to lock the database objects
securing the database objects have different ways:
1. Password protect the database
2. Password protect the VB codes
3. Disable allowbypasskey
4. Make MDE file for versions 2003 and previous
a. the simplest way to protect is by password protecting
b. Allowbypasskey diabling is a protection done by vb code
c. by making the MDE file, the forms, report, dap, macro, and modules are locked thereby it cannot be opened for editing or for opening.
d. by making ULS, the objects are locked by access, I think this goes by code again and we setup its password.
Therefore, protecting the database objects were done thru coding matched by password. So therefore, maybe there is a way that we can make our own CODE to lock the database objects.And I think our gurus here in this forum might help us out with that code.Can we do this?
Password Protect an Email Attachment in Access 2007
I am trying to password protect an attachment (in pdf) which is to be sent on a monthly basis to different employees. Actually it is a payslip. Is it possible to protect and open such an attachment?. I want to use a combination of employee name and employee id to open the attachment. I am using outlook for emailing purposes.
Please let me know on a possible solution for this
AllowEdit Range on excel spreadsheet via Access VBA
I am struggling a bit in Access VBA. I export files from Access vba and then open the file and do some formatting and then password protect that excel file. However I want the user to able to edit two columns. I try below code but it is not doing the job. It gives me runtime error 1004 Method Columns of object_Global failed.
.Visible = False
.Workbooks.Open (outpath + outfile1)
.ActiveSheet.Protection.AllowEditRanges.Add Title:="myRange", Range:=Columns("O:P"), Password:="pass"
import/export of forms with VBA code password
I'm trying to import a form from an older version of a database in an effort to keep from building it from scratch again. When I try to import from the new or export from the old I get an error message that says "Microsoft helps protect this Visual Basic for Applications Project with a password.
You must supply the password in the Visual Basic Editor before you can performthis operation"
I have the VBA editor open, with the correct password!
Cannot open VBA code
A few days ago my database suddenly started pumping out this error message:
"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code form modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project."
This message appears every time a form with VBA code is opened, and every time I try to open the VBA editor. Of course I have a backup, however I rather not be forced to redo about 6 hours of work.
Looking across the internet it seams like quite a few people have had this problem, but no solutions. As far is I can tell, something in the VBA code has caused the database to become corrupted.
So my question is this, is there any way I could possibly recover at least some of the code? Could I somehow force Access to show me the code, even if a part of it is corrupt?
Update table via VBA code
Have a table (several hundred entries) which must be updated weekly using VBA code. I know how to write the actual VBA code (for each record) but I do not know how/where/what is necessary to open the table, read each record seq and update based on VBA code (function call return value) and to finally close table.
Password Protect Autoexec
Is there a way to password protect the autoexec macro? If not, how would I go about securing that macro? I've noticed that you can import the autoexec macro to a blank database, manipulate the autoexec (i.e. disable shift-key bypass) and export the autoexec back into the database.
Note: the database is already split into FE and BE and both are password protected. The code is already password protected. I thought my system was secure but a friend whom I challenged to break into it was able to get to my code.
He confessed to manipulating the autoexec file so how is a guy supposed to secure his access system now
Password protect form
So I have an 'admin' form that I need to password protect. I can think of a couple different ways to do this(without user level security, which I'm not prepared to do)
The form will be access via a switchboard. Better yet, if I could password protect a certain switchboard, than I could put admin items on that board.
Password Protect Word Doc Through VBA
I have a word doc in the same folder as my access application. At the click of a button I want the access application to password protect my word doc without opening it (atleast not visible to the user)
Consider my word doc name as "MyWord.doc"
Password as "testPass
How Office helps protect you from phishing schemes
This article explains what phishing is and includes tips on how to identify phishing schemes and follow best practices to avoid becoming a victim of online fraud. This article also describes how the 2007 Microsoft Office system helps to protect you from phishing schemes.
In this article
* What is phishing?
* Examples and characteristics of phishing schemes
* How can Office help protect me from phishing schemes?
* Best practices to help protect yourself from online fraud
* How do I report online fraud and identity theft?
Protect from Delete
I have a database on a network drive. IS there a way to protect the database from being deleted?
Protect from Delete
I have a database on a network drive. IS there a way to protect the database from being deleted
[MSACC2010] Password protect backend?
I have a database built using MS Access 2010 which is a split database. Everything is working fine until some users found out the BE location. *Someone* then managed to change some user details in the tables. Luckily I have backups but I really want to prevent this happening again.
I noticed there is an option to password protect the BE but will this also mean users will have to enter a password when connecting from their FE? If so, are there any other alternatives to keep the BE safe? I was thinking of a simple login form on opening the DB but ultimately this can also be bypassed plus it's a lot of effort just to password protect the BE.
This is a fairly large company so I just wanted to make sure before I commit any changes.
Creating password protect form
I've an 'admin' form that I need to password protect in Access 2010. I can think of a couple different ways to do this(without user level security, which I'm not prepared to do) Any recommendations?
The form will be access via a switchboard. Better yet, if I could password protect a certain switchboard, than I could put all admin items on that board.
Password protect a form
How can I password protect access to a form? I have a public database that all employees use however I only want certain people to be able to view/edit one of the forms in it.
VBA Code Clean up?
I used the resources of this forum to get the proper code I needed to open and close forms at the click of a button and was able to get the code into the db and working properly.
Fast forward a few hours, with no changes made, and the click of a command button is now shutting down Access. At the advice of a co-worker, I grabbed an MZ-Tool for VBA code clean up, and my eyes glazed over. I'm not even sure if this is the issue, or the correct way to resolve.
There is VBA code on of the forms (6 in total).
Exporting to PDF via VBA Causing Database Corruption
I have a database that I have built that needs to export a large set of data to PDF for each county in Florida. If I manually export of these (without VBA code) to PDF, they work fine and my database does not go corrupt.
If I leave the code in VBA to export any county under 50,000KB, they all work perfect and the database does not corrupt. However, I have one relatively large PDF exports at 166,708KB.
As soon as I run the code to export this PDF file (and compact and repair my database thereafter) I get a error message upon re-opening the database stating that my VBA code is corrupt.
It then prompts me through some more error messages and it ends up erasing VBA code and any objects with VBA code attached. I'm just curious as to the reason why this file size is leading to a database corruption when it's coded into VBA.
Preventing Changes to your Microsoft Access VBA Code
If your database contains Visual Basic for Applications (VBA) code procedures, you want to ensure that your users can't make changes unless authorised or qualified to do so. Access to the code can be prevented in a couple of different ways: Password protecting your VBA code.Saving the database as a Microsoft Database Executable (MDE) format.