Bill,
Thanks
Russ
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> Russ
>
> FYI - To hide the Ribbon, use this command:
> DoCmd.ShowToolbar "Ribbon", acToolbarNo
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
> My nothing-to-do-with-Access blog
> http://wrmosca.wordpress.com
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "ghsclass65" <dyspoz2@> wrote:
> >
> > 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, 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
> > > 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]
> > >
> >
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (7) |
Tidak ada komentar:
Posting Komentar