Newbie Security Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have my database split on the server. Front end is in a Read Only folder,
accessible to many. Back end is inaccessible to all but me. When I split
the DB, the table icons changed their appearance. Do they become like
shortcuts so that, if I delete them, the back end tables will not be
affected? If I deleted the table icons, the only objects available to the
multiusers are the queries. I wanted to prevent users from going into Design
view. Is there an easy way to do that? Thanks. I promise. I'm reading a
manual on the side. H
 
Hughie said:
I have my database split on the server.
OK.

Front end is in a Read Only folder,
Click to expand...

If it's read-only then it won't work because Access needs to be able to
create the record locking file in that folder.
accessible to many. Back end is inaccessible to all but me. When I split
the DB, the table icons changed their appearance. Do they become like
shortcuts so that, if I delete them, the back end tables will not be
affected?
Click to expand...

Yes, they are linked tables which can be removed and re-linked.
If I deleted the table icons, the only objects available to the
multiusers are the queries.
Click to expand...

If you do this then your queries will have nothing to query!
I wanted to prevent users from going into Design
view. Is there an easy way to do that?
Click to expand...

Yes. Hide the database window, disable full menus (in tools ... startup)
and provide your own custom menus. Also set the AllowBypassKey property to
'false' so that holding down the shift key on startup has no effect. User
level security would be a good idea too but that's a whole other topic.
Thanks. I promise. I'm reading a
manual on the side. H
Click to expand...

I believe you :o)

HTH - Keith.
www.keithwilby.com
 
On the first point: I think the record lock file gets made because one
showed up after user accessed a query.
2nd point: So Access uses the front end table icons for the queries to link
to the back end tables?
3rd point: When I go into Tools/Startup, I see the ability to uncheck full
menus but it's unclear to me how to create a custom menu. Would you please
explain? Thanks, H
 
Hughie said:
On the first point: I think the record lock file gets made because one
showed up after user accessed a query.
2nd point: So Access uses the front end table icons for the queries to
link
to the back end tables?
Click to expand...

You use the linked tables in your queries.
3rd point: When I go into Tools/Startup, I see the ability to uncheck
full
menus but it's unclear to me how to create a custom menu. Would you
please
explain?
Click to expand...

Custom menus are available by right-clicking any menu bar and selecting
"customize".

Regards,
Keith.
 
Back
Top