logging in to an access db

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Dave F said:
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
Click to expand...

You need to join the custom workgroup that was created as part of the
securing process.

Keith.
www.keithwilby.com
 
Dave F said:
How do I join this custom workgroup?
Click to expand...

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.
 
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
 
Back
Top