Password Protection

[PowellGirlTN]

I want to split the database and have a different password for the front and
backend. Is this possible and if so, does it cause any problems.

 

[Olduke]

I want to split the database and have a different password for the front and
backend. Is this possible and if so, does it cause any problems.

The password function is not designed to do this.
You may be able to code your way around it, but don't be surprized if it
goes haywire.
Have you considered using the Group/User security function? This will allow
you to grant permissions to those who may and those who may not make changes.
Plenty of posts in this section on how to do it.

 

[Joan Wild]

I want to split the database and have a different password for the front and
backend. Is this possible and if so, does it cause any problems.

Yes it's possible. After you split and apply the password to the backend, open the frontend and delete the table links. Then recreate them, providing the password for the backend.

If the user needs to refresh the links, for some reason, they'll need to know the password (or you'd have to do it for them).

The database password isn't that secure - a quick search on google will give you lots of password crackers.