Linking an Access Database to one specific Workgroup Information

[Tbetts]

Alright, here's my situation. I work for a larger company that has all
networked computers, we use Windows 2000. We have Access 97 stored on
everyone's hard drive and everyone is automatically defaulted to use the
sytem.mdw file that it located on their hard drive. This is the generic
version. I am creating a few applications using Access in which I would like
to put read-only rights on certain tables and queries within that database.
I know how to create permissions and things like that, but I'm confused about
the .mdw files. I want to create a specific .mdw file that requires the user
to enter the Logon ID and a Password when they open my database. However,
since my group uses many other databases that don't have any kind of security
or permissions set up then I don't want them to be prompted for a LogIn and
Password when they open the other databases. Only mine. Is this possible?
Is there a way for me to tell my Access database to use a speicific .mdw file
when the database is opened? PLEASE HELP! This is driving me crazy! I hope
this makes senses.

Thank you,
Tanya

 

[Albert D. Kallal]

The standard approch to this problemis to use a shorcut.

In the shortcut, you can speicrfy the workgroup file. This is a good
approach, since ou will drive your users crazy if you join a a workgroup for
JUST ONE appciton..but now for ever more force a logon for each appliaton
that is run.

So, provicdee a shorcut to your suers. The Shocirtcuts typicall look like:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"c:\program files\RidesXP\RidesXP.mde"
/wrkgrp "c:\Program Files\Rides\Rides.mdw"

Note that the above would be all in "one line" of the short cut.

Also, for each application I am working on, I often make a "quick"
shortcut..and it already has the password etc set for me so that during
development..I don't get any logon prompts..as I am impatient. So, I ALWAYS
create a working shortcut for myself to "get in" to the application very
quickly. It will look like:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"c:\program files\RidesXP\RidesXP.mdb"
/wrkgrp "c:\Program Files\RidesXP\Rides.mdw"
/User "RidesAdmin" /pwd "XXXXXX"