• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • 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?
Eileen Murphy
Eileen Murphy
2 Solutions
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.
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.
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.

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

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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