Protect Backend Database

[Martin Hopkins]

Hello,

Could you please help on the follwoing problem:

Until recently I had a backend Access 2000 database on 1 server with a front
end database on the users home drive which used linked tables.

The backend was not secured other than windows file permissions. However, to
cut a long story short, someone has played with the backend and I have now
had to protect it with a password.

Unfortunately when a user logs into the database from the front end they are
asked for a password. The front end currently allows access to the forms etc
by way of use type located in a database table either user, admin or
superuser. This allows them access to certain parts of the forms/ reports
etc dependant on role authorised.

Now that the databae is passworded, how can I build this password into the
logon on screen to the front end database.

In other words the user is authorised to open the database becuase he has a
role in a database table, so let him/her access the database with the
password already "embedded" in the logon code script.

Thanks

Martin Hopkins

 

[Mikal via AccessMonster.com]

Now that the databae is passworded, how can I build this password into the

logon on screen to the front end database.

In other words the user is authorised to open the database becuase he has a
role in a database table, so let him/her access the database with the
password already "embedded" in the logon code script.

Thanks

Martin Hopkins

Try the advice here. Watch out for word-wrap in the URL:

http://www.accessmonster.com/Uwe/Fo...on-database-allow-users-to-open-front-end-w-o


HTH
Mike

 

[Joan Wild]

If you open the frontend and delete the table links, and then recreate them,
you'll be prompted for the backend password - that will get stored with the
link, and the user won't be asked again. You could do this on your copy of
the frontend, and then distribute the updated frontend to the users.