Opening Database on Others computers

[Jimruns919]

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.

[Micron]

To be clear, you're saying that this is not the way it works on your pc with you logged in? Then there may be an issue with your code but I think we'd have zero idea where to look at this point. Any chance you can copy db, compact/repair and zip the copy and post it?

[Welshgasman]

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.

Well the fault will likely lie with your logic for logging in?

Show your code. Better still upload enough to show the issue.

[Jimruns919]

On my computer, it hesitates but it runs correctly on my computer with me logged in.

When I log onto the test computer as me and then run the front end, it does the same thing.

If I log on as any user with the temp password, it will open the Change Password form and the user can update their password to the table and close the form but it still will not open the Main menu form.

I can upload it.

[Micron]

You probably will have to provide a password for your profile. The rest we can easily figure out as long as the table password field is not encrypted.

[Jimruns919]

here is the database. the Exit macro works. The change password form works but the main menu will not load when you click Login

[Micron]

You probably will have to provide a password for your profile.

and it looks to me like you left out a back end that contains the user table(s)

EDIT - maybe not. Perhaps my efforts to relink where not entirely successful. Hang on, trying again.

[Jimruns919]

And just so you know.

There are only 2 users on this version. Kim and her password is Password and Jim and his password is 12345

[Micron]

OK, relinked. But it takes 50 seconds for me to open user table with only 2 records. Slowness like that might be a problem for me. I will see what I can do.

[Welshgasman]

here is the database. the Exit macro works. The change password form works but the main menu will not load when you click Login

Too new for me.

[Micron]

I think your problem is that you open the login form modally but don't close it in code. When I step through (F8) the line to open menu form executes, screen flashes as though menu form opened but because you don't close the login form, it is preventing menu form from showing. I didn't test to see if it actually loaded hidden or not. I changed to

 If Userlevel < 9 Then
                    DoCmd.Close acForm, "Login_FRM"
                    DoCmd.OpenForm "MainMenu_FRM"

and successfully opened the menu form under your credentials. Then I used Kim credentials and was prompted to change the password. Then I changed the password to the new one as I presumed that would be the required thing to do. Then the menu form opened.

If that change does what you want then it may need to be applied elsewhere as well. Like what if level is not < 9?

[Jimruns919]

That did not do it on my end. I even changed the form to open to be the MainMenu_FRM but it will not open, so I am thinking the issue is on the Main menu form.

[Micron]

Forgot to mention that I set menu form modal property to No. I don't think a modal form will open if there is already a modal form open.

[Jimruns919]

Changing modal to no still didnt open the main menu. It does react as if it is opening something and there is not an error, but nothing is there.

[Jimruns919]

I figured it out. I changed the Main menu to Modal = Yes and now it opens.

Thank you for the help. Without your direction I would not have arrived at the solution.