Password in Linked db

[Beady]

Hi,

I'm using Access 97. I have an Access application that consists of two databases, a front end witht he usual forms, reports, queries etc. and a back end with the data.

I use my own simple logon form to restrict access at the front end, but nothing on the back end.

I really want to restrict access to the back end by placing a password on the database.

How do I still allow people who use the front end to get into the system and access the data, yet prevent them from accessing the back end directly?

I have put the password on the back end easily enough, but when I try to use the front end I just get the message, 'Invalid Password'.

Regards,
Bernard D

 

[Dennisk]

you require full workgroup protection. Search the forum for workgroup, security

 

[Beady]

Hi,

thanks for that, but Workgroup Security is probably much more complex than I need, plus as this is going on someone else's system I can't go messing about with their settings.

My worry about the whole Workgroup thing is that it always seems to impose security across all the databases on the system, instead of just the one that I want. If that happens then a lot of other systems they have, may stop working.

Regards,
Bernard D

 

[Dennisk]

If workgroup security is applied to the default system.mdw workgroup then yes that will apply to all databases that you open. The trick is to create a workgroup for each database that requires protection. Have you thought about the simple things that you can do such as hiding all the tables in the BE.

 

[Beady]

Ok,

thanks that makes sense, but won't people then need to log in using the workgroup username and password as well as the one that I provided?

I do 'stuff' with the information I gather when they use my logon, if I had to go through three and a half million forms to take all that out I'd be here until Christmas 2010.

Regards,
Bernard D

 

[Dennisk]

Beady,

You would replace the database password with workgroup protection. Infact you can set it up so that users only need to enter a User name and not user name and password.

 

[allan57]

Try the following link


http://www.access-programmers.co.uk/forums/showthread.php?t=123819