Security preventing me from exporting file to a snapshot Format

  • Thread starter Thread starter Chuck W
  • Start date Start date
C

Chuck W

Hi,

I want to be able to export a report to a snapshot file.
I created a form but have set it up for security purposes
so that a user cannot see the tables, queries and
reports. I can see these if I hold my shift key down and
open the application. If I hold my shift key down and
open my database and then go to a report, I can export it
to a snapshot format. However, if I open my database
without the shift key, I don't see the option to export
and report to the snapshot format. Is there a way to add
this capability for end users without having to allow
them to see all of the tables and queries (ie hold shift
key down)?

Thanks,

Chuck
 
Chuck W said:
Hi,

I want to be able to export a report to a snapshot file.
I created a form but have set it up for security purposes
so that a user cannot see the tables, queries and
reports. I can see these if I hold my shift key down and
open the application. If I hold my shift key down and
open my database and then go to a report, I can export it
to a snapshot format. However, if I open my database
without the shift key, I don't see the option to export
and report to the snapshot format. Is there a way to add
this capability for end users without having to allow
them to see all of the tables and queries (ie hold shift
key down)?
Click to expand...

Two different issues really. All you need for your users is to display a
menu bar that exposes the Export As... option. They don't need access to
the db window.
 
Rick,

Are you sure. When I hold my shift key down and open the
application I can export but if I don't hold the shift
key down I have an autoexec macro that makes a user type
in a password. The user cannot click out of the forms to
see the tables. I remember setting this up about a year
ago. I have been looking for adding toolbars for the end
users but can't seem to find this.

Thanks for your help.

Chuck
 
ChuckW said:
Rick,

Are you sure. When I hold my shift key down and open the
application I can export but if I don't hold the shift
key down I have an autoexec macro that makes a user type
in a password. The user cannot click out of the forms to
see the tables. I remember setting this up about a year
ago. I have been looking for adding toolbars for the end
users but can't seem to find this.
Click to expand...

A macro that asks for a password does nothing to inhibit menus. Do you
have the built-in menus disabled in the startup options? To create a new
toolbar or menu bar simply open with the shift key and then right-click on
an existing menu/toolbar and choose customize. Once in customize mode you
have the option of building new menu bars and toolbars. Just create one
that includes the options you want and use your startup options to display
it.
 
Back
Top