I built an access database and everything works great on my system.
I split the database and everything still works great so i added the front end to a users system and made their desktop trusted and all the tables are linked to a location on the server where everyone has access.
It opens without any errors and shows the log on form. If the user logs in with the wrong password it states the password is incorrect. If the password is the default password I put in which opens the form to change the password, it works.
However, if they log on with a user who has already changed their password, it will not show an error or show the next form. I am completely stumped.
The fact that they can open the password change form seems to mean that it is working, but I cannot figure out why it will not open the next main menu form when logged in correctly.