• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 349
  • Last Modified:

Prevent users from opening network version of Access application

Hi Experts. I'm looking for some advice on how to prevent users from opening a network version of a front-end. I have users opening the application by way of a batch file shortcut which copies the front-end to the user's local machine while retaining a link to the back-end. This prevents users from making changes to the front-end and also gives them the most current of the application each time they open it.

A client of mine has a user going into the network version and making changes to query and report designs, etc.

Can you give me some ideas on how to prevent this? I have a development copy in another location on the network and can keep doing things that way - but sometimes the user will leave the front-end in a locked state which causes problems too.

Any ideas?
0
Eileen Murphy
Asked:
Eileen Murphy
2 Solutions
 
pony10usCommented:
If the "front end" and "back end" are in different locations (folders) then i would set the permissions to the folder where the front end resides read only.  This will prevent users from saving any changes.
0
 
Dale FyeCommented:
It is difficult to "secure" an access backend from someone that is familiar.

One method I have used is to disable the "shift key" bypass, then add an auto exec macro that runs a sub routine.  In mine, I check whether the path of the current database is the network path, and if it is I display a message advising the user to use the appropriate front end application.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
As pony said, make the directory read-only for users.  This is what I do.

No points please.

Jim.
0
 
Dale FyeCommented:
Btw, I use the same technique with the network copy of the front end as I do with the backend.
0
 
Eileen MurphyIndependent Application DeveloperAuthor Commented:
Great suggestions. Thanks a lot as always!!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now