Russ,
What you have suggested is essentially correct. However, it doesn't matter
whether or not you have checked "Use Special Keys." Certainly make that
setting according to your needs in the production application. That setting
and the Hide Navigation setting will be in place when the application is
opened normally. When you hold the shift key while opening (this is known as
Shift-Key Bypass) then the Navigation pane and special keys option settings
will be ignored.
To "bullet proof" the production application so that the users can't also
bypass the settings with the Shift key, you need to disable the shift key
bypass property. For more information on how to do this see Jeff Conrad's
page http://www.accessmvp.com/JConrad/accessjunkie/shiftkey.html Personally
I like Ricky Hick's utility posted at UtterAccess.com
http://www.utteraccess.com/forum/ByPass-Shift-Key-Utility-t233728.html
<http://www.utteraccess.com/forum/ByPass-Shift-Key-Utility-t233728.html&hl=b
ypass> &hl=bypass
Glenn
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ghsclass65
Sent: Saturday, August 24, 2013 5:11 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Splitting database
Phil,
I am no expert with Access, but there are several things you can do to hide
the tables from the end user. 2010 may be slightly different but using
Access 2007 for example you can click on the little icon in the top left
corner of the open db and choose Access Options then select This Database
from that list. Try hiding the Navigation Pane but be sure you've checked
the box that says "Use Special Keys". Then when the user opens the db
assuming you have a form that opens when it starts - another selection under
Display Form, the left Navigation pane will be hidden.
Now, when you want to work on the db yourself you'll want that pane open, so
here is where the Use Special Keys comes in handy. When you click on the db
name, hold the shift key down and the pane will be visible to you. In older
versions of Access I was able to hide what's now called the ribbon, but I've
not stumbled upon that trick yet.
Russ
--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , Phil Knowles
<pdk444444@...> wrote:
>
> Hi Glenn
> Â
> I expected to control access to the data in the tables using forms,
reports queries etc but I didn't think the user would be able to open the
tables directly
> Â
> Phil
> Â
> Â
>
>
> ________________________________
> From: Glenn Lloyd <argeedblu@...>
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> Sent: Saturday, 24 August 2013, 13:25
> Subject: RE: [MS_AccessPros] Splitting database
>
>
> Â
>
> Linked tables are still visible in the Frontend because you need to work
> with them in queries forms and reports. The symbol you are seeing
indicates
> that the table is linked as opposed to native. If you try to open one of
> those linked tables in design view, Access should advise you that you
cannot
> modify it.
>
> Glenn
>
> From: mailto:MS_Access_Professionals%40yahoogroups.com
> [mailto:mailto:MS_Access_Professionals%40yahoogroups.com] On Behalf Of
pdk444444
> Sent: Saturday, August 24, 2013 7:09 AM
> To: mailto:MS_Access_Professionals%40yahoogroups.com
> Subject: [MS_AccessPros] Splitting database
>
> Hi guys
>
> This has got to be a simple one!!
>
> I am trying to split a database in access 2010 and have used the database
> tools - access database icon and it appears to have split the database.
>
> The back end is fine in that it shows me just the tables but the front end
> still allows me to get at the tables - surely they should not be either
> visible or accessible? The only difference seems to be that they are
> displayed with a + sign on the left hand side.
>
> What have i done wrong?
>
> cheers Phil
>
> [Non-text portions of this message have been removed]
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar