Access 2007 Navigation pane issues !

[ponneri]

Hi.

I find the Navigation pane settings confusing at times in Access 2007.

I've developed a small application and wish to deploy it with the user able to see only the forms and reports in it.

I don't want the user to see the queries or the code in them !

I've tried a few things with the Access Options menu - Current Database - Navigation menu settings but I'm unable to really hide my queries or other objects...as required.

Can someone help me please ?

 

[Minty]

If you convert a copy of your database to an accde it can't be easily modified. If you only install the access runtime on your end users pc's and not the full version of Access they can't do much at all!.

 

[bob fitz]

I believe that it is possible to change queries and edit tables with an accde file if the user has the full version of Access.

 

[ponneri]

I did try converting it to an accde file. I get a 'could not make accde file' error. why ?

 

[bob fitz]

Try to Compile your code from the code page of any module