|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
logging in to an access dbI was given a user name and password to login to an access 2000 db, however
when I open the db I don't get a login screen pop up. How do I get the login screen to pop up? Dave "Dave F" <Da***@discussions.microsoft.com> wrote in message You need to join the custom workgroup that was created as part of the news:96322F25-1068-4A57-BCDD-8E0CF0CA3FA9@microsoft.com... >I was given a user name and password to login to an access 2000 db, however > when I open the db I don't get a login screen pop up. How do I get the > login > screen to pop up? > > Dave > securing process. Keith. www.keithwilby.com How do I join this custom workgroup?
-- Show quoteHide quoteA hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Keith Wilby" wrote: > "Dave F" <Da***@discussions.microsoft.com> wrote in message > news:96322F25-1068-4A57-BCDD-8E0CF0CA3FA9@microsoft.com... > >I was given a user name and password to login to an access 2000 db, however > > when I open the db I don't get a login screen pop up. How do I get the > > login > > screen to pop up? > > > > Dave > > > > You need to join the custom workgroup that was created as part of the > securing process. > > Keith. > www.keithwilby.com > > > "Dave F" <Da***@discussions.microsoft.com> wrote in message First you need to locate the workgroup file. This file will have an "mdw" news:E62729DC-7D08-40FC-A12A-AFBB174CF2FA@microsoft.com... > How do I join this custom workgroup? extension. Next, you can either use the Workgroup Administrator on the Tools menu to browse to it or use a desktop shortcut to join it on a session-by-session basis. The shortcut needs to have a target of "Full path to MSACCESS.EXE" "Full path to your database.mdb" /wrkgrp "Full path to your workgroup file.mdw" including the quotation marks. The latter method is preferred since it will not prompt you for a password for "non-secure" databases. HTH - Keith. www.keithwilby.com OK, great thanks for the help.
Dave -- Show quoteHide quoteA hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Keith Wilby" wrote: > "Dave F" <Da***@discussions.microsoft.com> wrote in message > news:E62729DC-7D08-40FC-A12A-AFBB174CF2FA@microsoft.com... > > How do I join this custom workgroup? > > First you need to locate the workgroup file. This file will have an "mdw" > extension. Next, you can either use the Workgroup Administrator on the > Tools menu to browse to it or use a desktop shortcut to join it on a > session-by-session basis. The shortcut needs to have a target of > > "Full path to MSACCESS.EXE" "Full path to your database.mdb" /wrkgrp "Full > path to your workgroup file.mdw" > > including the quotation marks. The latter method is preferred since it will > not prompt you for a password for "non-secure" databases. > > HTH - Keith. > www.keithwilby.com > > > Just because you're using a shortcut and getting a login prompt, doesn't
mean your mdb is secure. Your first post said that you were able to open it without a username/password. That indicates that it wasn't secured properly, since you were using the standard system.mdw rather than your secure mdw. -- Show quoteHide quoteJoan Wild Microsoft Access MVP "Dave F" <Da***@discussions.microsoft.com> wrote in message news:D774CEB7-C33A-46A1-A580-D317CD4A0EE1@microsoft.com... > OK, great thanks for the help. > > Dave > > -- > A hint to posters: Specific, detailed questions are more likely to be > answered than questions that provide no detail about your problem. > > > "Keith Wilby" wrote: > >> "Dave F" <Da***@discussions.microsoft.com> wrote in message >> news:E62729DC-7D08-40FC-A12A-AFBB174CF2FA@microsoft.com... >> > How do I join this custom workgroup? >> >> First you need to locate the workgroup file. This file will have an >> "mdw" >> extension. Next, you can either use the Workgroup Administrator on the >> Tools menu to browse to it or use a desktop shortcut to join it on a >> session-by-session basis. The shortcut needs to have a target of >> >> "Full path to MSACCESS.EXE" "Full path to your database.mdb" /wrkgrp >> "Full >> path to your workgroup file.mdw" >> >> including the quotation marks. The latter method is preferred since it >> will >> not prompt you for a password for "non-secure" databases. >> >> HTH - Keith. >> www.keithwilby.com >> >> >> Joan, that occurred to me as well. The database is not properly
secured, as you note, because it was created by someone who had never used Access before. At this point its lack of proper securing is not really a concern because it will be replaced by a SQL-server based database. My problem was I needed to document the SQL statements used and in order to do that I had to be able to log in and see its design. Thanks, Dave Show quoteHide quote On Mar 15, 1:45 pm, "Joan Wild" <j...@nospamtyenet.com> wrote: > Just because you're using a shortcut and getting a login prompt, doesn't > mean your mdb is secure. Your first post said that you were able to open it > without a username/password. That indicates that it wasn't secured > properly, since you were using the standard system.mdw rather than your > secure mdw. > > -- > Joan Wild > Microsoft Access MVP"Dave F" <D***@discussions.microsoft.com> wrote in message > > news:D774CEB7-C33A-46A1-A580-D317CD4A0EE1@microsoft.com... > > > > > OK, great thanks for the help. > > > Dave > > > -- > > A hint to posters: Specific, detailed questions are more likely to be > > answered than questions that provide no detail about your problem. > > > "Keith Wilby" wrote: > > >> "Dave F" <D***@discussions.microsoft.com> wrote in message > >>news:E62729DC-7D08-40FC-A12A-AFBB174CF2FA@microsoft.com... > >> > How do I join this custom workgroup? > > >> First you need to locate the workgroup file. This file will have an > >> "mdw" > >> extension. Next, you can either use the Workgroup Administrator on the > >> Tools menu to browse to it or use a desktop shortcut to join it on a > >> session-by-session basis. The shortcut needs to have a target of > > >> "Full path to MSACCESS.EXE" "Full path to your database.mdb" /wrkgrp > >> "Full > >> path to your workgroup file.mdw" > > >> including the quotation marks. The latter method is preferred since it > >> will > >> not prompt you for a password for "non-secure" databases. > > >> HTH - Keith. > >>www.keithwilby.com- Hide quoted text - > > - Show quoted text - |
|||||||||||||||||||||||