logging in to an access db

[Guest]

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

 

[Keith Wilby]

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

 

[Guest]

How do I join this custom workgroup?

 

[Keith Wilby]

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

 

[Guest]

OK, great thanks for the help.

Dave

 

[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.

 

[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