How to create a password access within Database

[Gasman]

DlookUp return a Null if not found though?

? dlookup("FoodName","tblFoods","FoodID=500")
Null

 

[Mark_]

A very simple solution is to have a stand alone app that just deals with employees. App is provided to only those who have network access, so you don't have to reinvent the wheel.

As soon as you add even one "Secure" page you will find it much easier to require security as Pat posted. One form leads to "Oh, now we need this report, now we need this other form, we need to track the following metrics, ect...

A separate application that has just the pieces management wants and that is secured by your existing network permissions avoids most of the headaches, at least during development.

 

[John Lee]

Hi CJ, thank you, your original snippet did the trick, and yes none of the users will be able to gain access to the behind the scenes of the database, they will only be able to see the form views. I like to the look of what you have just suggested and so I think I will test it out, thank you once again.

Hi CJ, just had a thought as I'm currently developing this database on my home computer it will be deployed on my work network which is cloud based, so people have to log into the cloud to access all the companies files/folders etc. So will that snippet of code still work based on their login details to the cloud?

 

[CJ_London]

. So will that snippet of code still work based on their login details to the cloud?

Access (front end) doesn’t work in the cloud. It is a client based application. If by cloud you mean terminal server or Citrix which runs via Remote Desktop then each user has their own profile- so should work.

Each user has their own copy of the front end located locally to them- if you are thinking they will all use the same physical front end file, think again - it can be done but is guaranteed to corrupt at some point.