Ask password to a securised mdb

[Amirallia]

Hello,

I developed into toto_app.mdb an application with forms, and reports ,
everything working with attached tables where is in a another *.mdb,
toto.mdb, which contains only tables with the data.

Everything works well, now my customer requires to define a password on
toto.mdb, because this file is on the network and he will that nobody
can open it and read it. So I defin the password on toto.mdb, by the
menu to >tools>Set a password.

Now when I launch toto_app.mdb, I have this message : "passwords
invalid", but no possibility to enter a password!!!

An idea? or another method to securise my data into toto.mdb?

Thank you

 

[Joseph Meehan]

Hello,

I developed into toto_app.mdb an application with forms, and reports ,
everything working with attached tables where is in a another *.mdb,
toto.mdb, which contains only tables with the data.

Everything works well, now my customer requires to define a password
on toto.mdb, because this file is on the network and he will that
nobody can open it and read it. So I defin the password on toto.mdb,
by the menu to >tools>Set a password.

Now when I launch toto_app.mdb, I have this message : "passwords
invalid", but no possibility to enter a password!!!

An idea? or another method to securise my data into toto.mdb?

Thank you

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

Password security is rather weak and inflexible in Access.

 

[Guest]

With the way linked tables work you are going to have to reestablish the
links to the back end. It will then prompt you for the password to the
toto.mdb database. Access will then retain the password in the toto_app.mdb
for future users.