Convert mdb file to accdb with the same protection

[ameedoo3000]

I had an Access database on the 2003 version of Mdb and I hide the forms, reports and ...... with this code


Application.SetHiddenAttribute acForm, "Form_name", True


now i have converted the file to the 2010 format accdb format,but an error occurs in this code
Application.SetHiddenAttribute acForm, "Form_name", True


Please explain and explain why.

[John_G]

What is the error message you are getting?

[ameedoo3000]

I had an Access database on the 2003 version of Mdb and I hide the forms, reports and ...... with this code
Application.SetHiddenAttribute acForm, "Form_name", True


now i have converted the file to the 2010 format accdb format,but an error occurs in this code
Application.SetHiddenAttribute acForm, "Form_name", True


Please explain and explain why.

I want to prevent anyone from importing of objects the Access project such as forms, reports, tables, modules, etc.
So I hide those objects using the above code, and this was in the 2003 version and when I this upgraded to the 2007 version, this code did not work and an error message appears

[CJ_London]

Based on the info provided you have a form called ‘form_name’. Seems very unlikely to me and I suspect is the reason for the error, whatever it may be. Cannot make any further suggestions until you answer post#2

[isladogs]

Agree with previous answer
That code still works in newer versions of Access and is doing exactly the same thing as right clicking on the object in the nav pane and selecting Hide

FYI that's really not at all secure as hidden objects can easily be shown by clicking Show Hidden Objects in Navigation Objects

[ameedoo3000]

What is the effective way to hide project subjects ?

[isladogs]

I've no idea why you are getting that error ...nor is it clear what 'project subjects are'

However if you mean how do I hide database objects in the navigation pane, the easiest way is to:
a) hide the navigation pane - see this example database Manage the Application Interface
b) hide Access Options in the File menu (so users can't reverse that)

If you just want to prevent changes to the design of forms & reports or importing of those objects from another database, change to ACCDE before distributing.
For more info on security, see this article on my website: Improve security

[ameedoo3000]

please ... how can i hide the navigation pane and how can i hide Access option ?
please more explain ...

[isladogs]

As I have already stated, try my example application and study the code supplied.

[ameedoo3000]

Sorry link does not work

[isladogs]

Sorry about that. Both links work now

[ameedoo3000]

please attach this example ..

[isladogs]

Both links are now working. Download the example from the first of the linked webpages

[ameedoo3000]

i allready download the example but any one can unhide my objects . so my problem is stell stand
i want to hide all objects in my project that any one can not import it any way
Is this in the possibility of Access databases?

[isladogs]

See posts 10 & 12 in this parallel thread
https://www.accessforums.net/showthread.php?t=75612