password problem

[brino]

hi all !

i have developed a database for a client which is working fine ,
however another developer has sold another database to this client and
in this database the developer has inserted some type of code to ask
for a password everytime the database is opened.
the problem is that they have set it up somehow to ask for the
password everytime MS Access is opened so it asks for a password when
my database opens even though i have not set up a password at all.
this is a source of trouble to my client because my database also
connects to another database that i also designed so everytime the
client moves from one section to the next he has to enter a password.
how can i turn off the password for my database ??

thanks
brino

 

[Joan Wild]

It sounds like you are being asked for a username/password, not just a
password.

I also am guessing that the other developer has set the default workgroup to
their secure mdw. The proper way to do this would have been to leave the
default set at system.mdw, and to set up a shortcut for the secure mdb.

The default is used for all sessions of Access. It should be left as
system.mdw (which ships with Access). A desktop shortcut would be used for
the secure mdb. The shortcut would use the /wrkgrp switch to override the
default.

If you open Access and go to Tools, Security, Workgroup Administrator, you
can see what is set as the default. If it is set to system.mdw, and users
are not using a desktop shortcut to start Access or any database, then it's
possible that the other developer has over-written system.mdw (a very rude
thing to do).

Post back with some more details. Is a shortcut used to start Access? What
is the target?. What path/filename is the default mdw set to?