Hi, Arno.
>That means the current workgroup (which ought to be the default
workgroup)
has a password for the default Admin user. That's inconvenient. Every
database you open in Access 2007 will require the User ID and password to
open the file, whether it's secured or not.
I don't think that is correct.
Test it for yourself. When he tries "to open it, I get a user name and
password prompt." Join a workgroup that has no password set for the default
Admin user. You won't be prompted for a User ID and password when you open
_any_ Access database by double-clicking on the file name. (You won't be
able to open it, either, if it's a secured database.) Add a password to the
Admin user. Next time you open _any_ Access database by double-clicking on
the file name, you'll be prompted for a User ID and password.
One gets the User ID and password prompt if and only if the default Admin
user has a password assigned in the workgroup one is currently joined to.
One doesn't get this prompt merely because one is attempting to open a
secured database.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog:
http://DataDevilDog.BlogSpot.com http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Arno R" <ar***********@tiscali.nlwrote in message
news:45***********************@text.nova.planet.nl ...
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AMschreef
in bericht news:12*************@corp.supernews.com...
>Hi.
>>(mdw). When i move it over to a system that has Access 2007 and try
to open it, I get a user name and password prompt.
That means the current workgroup (which ought to be the default
workgroup)
has a password for the default Admin user. That's inconvenient. Every
database you open in Access 2007 will require the User ID and password to
open the file, whether it's secured or not.
>I don't think that is correct. It only means that the default admin user
can not log in the db.
That only means the security *might* be done as it needs to be done...
You need to log in using the *same* mdw that is used by the other version
OR to get rif of the >security.
To get rid of the security of the mdb just open the mdb in the earlier
version (logged in as >'owner' or admin while 'using' the mdw) and create a
new mdb.
Import all objects in this new mdb.
Result: The database is not secured anymore and can be used with Access
2007 ??
The last I do not know for sure as I don't use Access 2007 yet...
Arno R