Client not able to log into Front End

**jeffhanner** · 09-10-2022, 08:46 AM

My database is split. To access the program, I created a login for each user with certain visibility and the login accesses a backend table. My users have shared access to the backend and can login without a problem, however when they try to access the front end it says they don't have permission for the shared sight. I'm not sure where to start on this. Any thoughts?

Jeff

**moke123** · 09-10-2022, 11:06 AM

Do they each have a copy of the front end on their local machine?

**jeffhanner** · 09-10-2022, 12:50 PM

Originally Posted by moke123

Do they each have a copy of the front end on their local machine?

Yes they do have a copy of the front end on their local machine.

**mike60smart** · 09-10-2022, 01:08 PM

Hi Jeff

Is the database in a Trusted location?

**CJ_London** · 09-10-2022, 01:57 PM

Do your users have read/write permissions for the backend folder?

**jeffhanner** · 09-10-2022, 04:16 PM

Originally Posted by mike60smart

Hi Jeff

Is the database in a Trusted location?

Yes'
And Yes the database is in a trusted location. Remember that they can reach the backend file with not problem. it is locking iin the same shared location for the tables during login to the backend.

**orange** · 09-10-2022, 04:22 PM

How do users reach the backend if they are NOT going through the FE??

Your Login form is in FE, right?

You might get some ideas from this Steve Bishop video re Login

**jeffhanner** · 09-10-2022, 04:34 PM

Some users just use the backend with Power BI to get reports.
I will watch the Steve Bishop video. Thanks

**jeffhanner** · 09-10-2022, 04:52 PM

Steve's video was good, but I already have a successful login form which we have been using all along, before I split the database.

**orange** · 09-10-2022, 05:32 PM

I'm not familiar with PowerBI. Are you saying PowerBI is a separate "entity/thingy" that can directly connect with the backend? Sounds like PowerBI bypasses your Login form/setup.

**jeffhanner** · 09-10-2022, 07:15 PM

Originally Posted by orange

I'm not familiar with PowerBI. Are you saying PowerBI is a separate "entity/thingy" that can directly connect with the backend? Sounds like PowerBI bypasses your Login form/setup.

I was with the user when they logged into the backend separately, but you may be right about Power BI. I think I have to do some more testing with the users.
Thanks for those questions.

Client not able to log into Front End

Thread Tools

Client not able to log into Front End

Similar Threads

Push (copy) updated Front-end FE from server to client machine -- using AutoUpdater

Display birthday for client and client's spouse

Link access front end from client computer to SQL back end in server computer

VBA code in front-end database not working on client computer

Auto generate client number for each new client

Tags for this Thread

Posting Permissions