Home All Groups Group Topic Archive Search About

logging in to an access db

Author
13 Mar 2007 2:19 PM
Dave F
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

Author
13 Mar 2007 3:41 PM
Keith Wilby
"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
Author
13 Mar 2007 3:46 PM
Dave F
How do I join this custom workgroup?
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


Show quoteHide quote
"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
>
>
>
Author
13 Mar 2007 4:23 PM
Keith Wilby
"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
Author
13 Mar 2007 4:43 PM
Dave F
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.


Show quoteHide quote
"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
>
>
>
Author
15 Mar 2007 5:45 PM
Joan Wild
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
Show quoteHide quote
"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
>>
>>
>>
Author
16 Mar 2007 12:33 PM
Dave F
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 -