Ms Access Login form and User Level

Question

I am trying to make Login Form Using DCount and LookUp functions 

My table has the following field LoginID, UserName, Password, Level and Description

Form has:

Combobox Named: "txtUser" bound column is 1 (LoginID) and I hide it by sitting Column Widths by 0

TextBox Named "txtPass"

Login Button and I use If function with AND but it does not work, access alway open the main form to me he did not use "else"

1. I want to say If txtUser and txtPass Mach then, show me message said Successfully, Close Login Form, Open the Main Form, else show me message said Failed, but access does not match "AND" he always open the Main form even If I put wrong password

If

I did this DCount("LoginID","LoginT","UserName=[txtUser]" And "Password=[txtPass]")

I did this DCount("LoginID","LoginT","UserNamer=[txtPass]") And ("Password","LoginT","Password=[txtPass]")

I did this DCount("LoginID","LoginT","UserNamer=[txtPass]" And "Password","LoginT","Password=[txtPass]")

I did this DCount("Password","LoginT","Password=[txtPass]")

they did not work

2. How can I add Level deal with Levels by LookUp?

if the txtUser and txtPass Mach and his Level is 1 as admin open the Main form as edit, else as Read only

Answer 1

Is it free to use? asp+mdb

Please explain more about this subject

Answer 2

Firstly, you shouldn't be building any MDB databases in 2021 as they are deprecated for at least 15 years now.  So be sure to develop ACCDB databases.

It is I'll advised to build any web based system off of any Access database.  If you're doing the route of a web interface then use any number of alternate RDMS' available on the market such as MySQL, SQL Server, PostgreSQL, ....

Note the there is quite a learning curve to building such systems, more than learning Access.

If you want to learn about asp, then start with https://docs.microsoft.com/en-us/aspnet/overview .   Also note such interfaces require servers to run, so you have to get IT onboard and supporting you.  You'll also need other development tools and things like Office automation are much more difficult, or even no longer even possible.

Answer 3

Hi ssdusd,

Firstly, it's OK to use your real name. You're among friends.

Reading between the lines you are tasked with developing an application that does ???, and it requires users to login. You are also working for a company that does not allow VBA to be used.

Assuming the app you speak of is non-trivial, then it cannot be efficiently and successfully be developed in Access without VBA. You can show my response to your superiors. I have 25+ years of development experience with Access so I know what I am speaking of.

Superiors need to give you the tools to be successful. If VBA is indeed OUT OF THE QUESTION for really good reasons (e.g. you are working for a financial institution and there are federal rules about what you can and cannot do), then you should be directed to tools that ARE compatible with those requirements. Maybe those are web tools, maybe they are other desktop tools, you need to know that before you can embark on a successful project. So your job is to ask nicely, but also to be insistent that you are given the tools to be successful. Access + Macros does not qualify.

Once that is in place, and only when it is, we can have a conversation about next steps.

Answer 4

Hi, Tom van Stiphout

Thank you for your advice,

in our company for secureity reason they block VBA to all employee, but I do not want to give up, becuse sometimes we can solve it by Macros.

all of you did great job!

Thank you everyone for your help and support, and I am sorry, what should I do I can not change compny policy

Answer 5

No, you can't change the policy, but your managers can.  As it has been stated several times, trying to develop proper Access solution without VBA is not possible. 

As I said previously, they've given you a car, but removed the engine!  Sure it will rolls, but you won't go anywhere very fast and forget going uphill.

This policy is costing the company $$$ (big money in reality).  With VBA you would have already been done and then some.

As also stated, if your company is dead set on not changing their policy, then they need to tell you which tool to use, as Access is inappropriate with their setup vs. needs.  Which programming tool will they allow and provide you with.

Lastly, if security is such a concern with your company, I truly don't see how they would allow an Access back-end to store any data!  So you may wish to look into that before continuing any further.

Lastly, best of luck to you.  It is sad to see you in such a situation as Access can be a formidable tool, but the way you have to use it is simply infuriating and frustrating.  Macros are very annoying to develop.