Security Password for DB

[isetea]

Hi,
I wanted to set a database password, but an error pops up asking for opening the database exclusively. But even with doing this, it does not stop showing this error.
What could be the reason ?
[I created the database and am the administrator]
Cheers

[PEB]

Hi,

Have you tried to compact and repair the database?

:)

[isetea]

Yes, no prob...
But still no password possible...

Hi,

Have you tried to compact and repair the database?

:)

[PEB]

So try to remove it!

Then Compact repair and then set it!

:)

[isetea]

I'm sorry, but how can I remove a password??? Already when I want to enter Tool\Security\S et Database Password the error message occurs?

So try to remove it!

Then Compact repair and then set it!

:)

[PEB]

Hi,

Very complicated!

Are u sure that u enter in exclusive mode to do this?

:)

Some info from Microsoft:

If you use a database password, all users must enter that password before they are allowed to open the database. Adding a database password is an easy way to help prevent unwanted users from opening your database; however, once a database is open, no other security measures are provided unless user-level security (user-level security: When using user-level security in an Access database, a database administrator or an object's owner can grant individual users or groups of users specific permissions to tables, queries, forms, reports, and macros.) has been defined as well.

Microsoft Access stores the database password in an unencrypted form. If this will compromise the security of the password-protected database, you should not use a database password to help protect the database. Instead, you should define user-level security to help control access to sensitive data in that database.

[isetea]

Hi,
I know not an easy topic. :(
I have the db exclusivly open. I set up the properties or options like that. Moreover if you open the database once exclusively, it seems to remember that and the next time you do it again.
I have already entered a workgroup and am working with user and group permissions. So no worries about the data, but I use data from another database (linked tables) and for it I only want a password. That's why I'm trying.
But thanks anyway. Than I need to enter user permissions there as well.
Cheers
:)

Hi,

Very complicated!

Are u sure that u enter in exclusive mode to do this?

:)

Some info from Microsoft:

If you use a database password, all users must enter that password before they are allowed to open the database. Adding a database password is an easy way to help prevent unwanted users from opening your database; however, once a database is open, no other security measures are provided unless user-level security (user-level security: When using user-level security in an Access database, a database administrator or an object's owner can grant individual users or groups of users specific permissions to tables, queries, forms, reports, and macros.) has been defined as well.

Microsoft Access stores the database password in an unencrypted form. If this will compromise the security of the password-protected database, you should not use a database password to help protect the database. Instead, you should define user-level security to help control access to sensitive data in that database.