|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Login to AccessWe recently upgraded from Office 2000 to 2007, when opening a database when
we had 2000 you had to login with a user id and password, this told the software who was entering data, since the upgrade the login no longer appears and everyone is shown as an Admin. All the users are not missing, I've tried adding new users but the login window still does not appear when opening a database, how do I get it back? -- Scottie The fact that you don't get a login screen, suggests that it never was secured properly (even in 2000).
I assume this is a mdb, and not a accdb. If you converted to the accdb, then security is gone; it's not supported in 2007. If you kept the mdb format and are just using 2007, then you can create a desktop shortcut to specify the secure mdw to use. The target would have the following in it: "path to 2007 msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw" However, you'll still have the problem that it isn't secure. -- Joan Wild Microsoft Access MVP Show quote "scotsman" <scots***@discussions.microsoft.com> wrote in message news:A5912B3D-B36F-4C5E-9F76-7A3B0EDB15DB@microsoft.com... > We recently upgraded from Office 2000 to 2007, when opening a database when > we had 2000 you had to login with a user id and password, this told the > software who was entering data, since the upgrade the login no longer appears > and everyone is shown as an Admin. All the users are not missing, I've tried > adding new users but the login window still does not appear when opening a > database, how do I get it back? > -- > Scottie Actually its a .mde file, I haven't converted the database, this seemed to be
a global setting, as whenever you open any access database file it required you to login. I have seen the target path you gave in this forum and tried it but just got an error message, I think I'm not understanding the part with the \wrkgrp. should that be in ""? We had it setup that way so we would know who added a record, international and FDA requirements. Thanks for your help. -- Scottie Show quote "Joan Wild" wrote: > The fact that you don't get a login screen, suggests that it never was secured properly (even in 2000). > > I assume this is a mdb, and not a accdb. If you converted to the accdb, then security is gone; it's not supported in 2007. If you kept the mdb format and are just using 2007, then you can create a desktop shortcut to specify the secure mdw to use. > The target would have the following in it: > "path to 2007 msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw" > > However, you'll still have the problem that it isn't secure. > > -- > Joan Wild > Microsoft Access MVP > "scotsman" <scots***@discussions.microsoft.com> wrote in message news:A5912B3D-B36F-4C5E-9F76-7A3B0EDB15DB@microsoft.com... > > We recently upgraded from Office 2000 to 2007, when opening a database when > > we had 2000 you had to login with a user id and password, this told the > > software who was entering data, since the upgrade the login no longer appears > > and everyone is shown as an Admin. All the users are not missing, I've tried > > adding new users but the login window still does not appear when opening a > > database, how do I get it back? > > -- > > Scottie > It should be /wrkgrp not \wrkgrp. That tells access to use the mdw specified in the path that follows (rather than the mdw that is set as the default).
-- Joan Wild Microsoft Access MVP Show quote "scotsman" <scots***@discussions.microsoft.com> wrote in message news:757F78CA-79AA-4B35-B6B1-E8D7B644C4DE@microsoft.com... > Actually its a .mde file, I haven't converted the database, this seemed to be > a global setting, as whenever you open any access database file it required > you to login. I have seen the target path you gave in this forum and tried > it but just got an error message, I think I'm not understanding the part with > the \wrkgrp. should that be in ""? We had it setup that way so we would > know who added a record, international and FDA requirements. > Thanks for your help. > -- > Scottie > > > "Joan Wild" wrote: > >> The fact that you don't get a login screen, suggests that it never was secured properly (even in 2000). >> >> I assume this is a mdb, and not a accdb. If you converted to the accdb, then security is gone; it's not supported in 2007. If you kept the mdb format and are just using 2007, then you can create a desktop shortcut to specify the secure mdw to use. >> The target would have the following in it: >> "path to 2007 msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw" >> >> However, you'll still have the problem that it isn't secure. >> >> -- >> Joan Wild >> Microsoft Access MVP >> "scotsman" <scots***@discussions.microsoft.com> wrote in message news:A5912B3D-B36F-4C5E-9F76-7A3B0EDB15DB@microsoft.com... >> > We recently upgraded from Office 2000 to 2007, when opening a database when >> > we had 2000 you had to login with a user id and password, this told the >> > software who was entering data, since the upgrade the login no longer appears >> > and everyone is shown as an Admin. All the users are not missing, I've tried >> > adding new users but the login window still does not appear when opening a >> > database, how do I get it back? >> > -- >> > Scottie >> another thing you may try, since you don't need to assign actual user
rights, and only need the name, in the table, create the UserCreated field. Then on the form you need to know who did something, set the default to =Environ(USERNAME). Lock the field on the form, and they can't change this. I don't know if this helps, I hope so. Show quote "scotsman" <scots***@discussions.microsoft.com> wrote in message news:A5912B3D-B36F-4C5E-9F76-7A3B0EDB15DB@microsoft.com... > We recently upgraded from Office 2000 to 2007, when opening a database > when > we had 2000 you had to login with a user id and password, this told the > software who was entering data, since the upgrade the login no longer > appears > and everyone is shown as an Admin. All the users are not missing, I've > tried > adding new users but the login window still does not appear when opening a > database, how do I get it back? > -- > Scottie  |
|||||||||||||||||||||||
Other interesting topics