Re: User access on a company intranet

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Dan wrote:
They do have full permissions to the folder that the front end of the
database is located but not on the backend.

Everyone should have their OWN local copy of the front end. Only the back
end should be shared.

Do I need to put the
backend in a folder that they have full access?

Yep.

If I do this do I
need to relink the tables.

Yep.



--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages

  • RE: Split db and have backend on local PC
    ... Dave Hargis, Microsoft Access MVP ... install an upgrade will not affect the backend tables and the user will have ... install it on another computer then the front end can not find the back end. ... subfolder of your user name folder. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Sharing a Secure Database on a network
    ... Put the backend on the ... Since you have secured your database, ... The currentUser() function can be used to retrieve the Access ... Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: VERY large lookup table
    ... Dave Hargis, Microsoft Access MVP ... For it to be dynamic, each time a user added a new entry, the backend would ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Exclusive Access
    ... Microsoft Access MVP ... Clois Beckwith wrote: ... "Joan Wild" wrote: ... backend or the frontend in exclusive mode, ...
    (microsoft.public.access.security)
  • Re: VERY large lookup table
    ... For it to be dynamic, each time a user added a new entry, the backend would ... Dave Hargis, Microsoft Access MVP ...
    (microsoft.public.access.tablesdbdesign)