Back-End database password

[Alireza355]

Dear all,

I have a database, splitted into front-end and back-end versions.

I want to set a password for the back-end database, but when I do so, the front-end users can not have access to information in the tables of the back-end one.

Any idea?

[NeoPa]

This is not true Ali.

If you set a password to the BE db, the FE can connect just fine as long as you give the password in your development version of it when setting up the connection.

I use this on the rare occasions when I give out FE dbs to untrusted users. It works fine.

[Alireza355]

Password Problem

Dear NeoPa,

Thank you so much for your kind support.

Here is the senario:

There are some forms and tables in the back-end database, that only one user must have access to. There are also some other tables in that database, which only the front-end users need to have access to with the forms that are only in the front-end users' database.

In fact, I have divided my office into two different sections by doing this. The accountant uses the back-end db and enters data in the tables using his own forms.

The sales personel enter sales information in the tables (that are in fact in the back-end db) using some forms that are placed only in the front-end db.

Now, I want to have a password for the back-end db, so that nobody else except the accountant can open the back-end db. But the front-end users should freely do whatever they want in their own environment.

If I set a database password for the back-end db, the subforms in the front-end are empty!!!!!!

[NeoPa]

Try this :

1. In case there is any misunderstandin g here of the process, I suggest you make a good backup of all your databases before commencing this.
2. Add the password to the BE db.
3. Delete and re-add all the linked tables from the FE db (passing the new password).
4. Release the new version of the FE db.

[Alireza355]

Thanx a lot

WOW!

IT WORKS!!!!!!!!!! !!!!!!!!!!!!

Thank you soooooooooooooo oooooooooo much

[NeoPa]

You sound surprised Ali ;)

You're welcome of course :)