Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Security / September 2004

Tip: Looking for answers? Try searching our database.

Linking windows log in to database ID?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Richard C - 17 Sep 2004 10:45 GMT
I was wondering if there is anyway of linking the windows
log in function to the access data base security log in.

It would make a lot of sense once somebody has logged in
that the data base log in was also done!!!

Richard C
'69 Camaro - 17 Sep 2004 11:56 GMT
Hi, Richard.

> I was wondering if there is anyway of linking the windows
> log in function to the access data base security log in.

For security reasons, this is _not_ recommended.

> It would make a lot of sense once somebody has logged in
> that the data base log in was also done!!!

It's easy to add this task to the Windows startup.  Just place a Windows
shortcut to open the database using the workgroup information file in the
user's startup directory.  The user will be prompted for the Access User ID
and password before getting started on anything else for the day, like
checking E-mail or grabbing a donut and a cup o' java.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

> I was wondering if there is anyway of linking the windows
> log in function to the access data base security log in.
[quoted text clipped - 3 lines]
>
> Richard C
david epsom dot com dot au - 20 Sep 2004 05:02 GMT
There is no exact way to do this, because the Access
Login system predates the Windows Login system, and
has never/not yet been upgraded to take advantage of
the 'new' (!!!) functionality.

There are a number of workarounds, which basically
involve not using the Access login, (or at least
not using user passwords).

Perhaps the cleverest suggestion was that made by Garry
Robinson: he suggested putting the (split) database or
workgroup into the users profile, so that only the user
with the true windows login can use it.

(david)

> I was wondering if there is anyway of linking the windows
> log in function to the access data base security log in.
[quoted text clipped - 3 lines]
>
> Richard C
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.