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 / Multiuser / Networking / December 2003

Tip: Looking for answers? Try searching our database.

Security?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bob Parr - 24 Dec 2003 19:24 GMT
I have an asset database that I want to keep track of what user is entering
new assets.  I need a way to ask who is about to use the database (possibly
with a password) then add that person as a field to the main data table.  I
think using user-level security is the easiest way to do this, but I want
this user info to be tied to the database.  I think user-leval is set up on
each PC (or installed instance of access).  The database will be stored on a
server and accessed by several different PCs

Bob
Douglas J. Steele - 24 Dec 2003 20:58 GMT
Security is set up through a combination of the application MDB itself, and
a System database (.MDW) file. It is not PC related, nor associated with
msaccess.exe itself. To learn how to apply Access security properly, read
the Access Security FAQ thoroughly several times, make sure you don't skip
any steps (and work with a copy of your database, just in case)

http://support.microsoft.com/support/access/content/secfaq.asp

BTW, you may want to rethink your design a little. You should have your
application split into a front-end (containing the queries, forms, reports,
macros and modules), linked to a back-end (containing the tables). Only the
back-end should be on the server: each user should have his/her own copy of
the front-end, preferably located on their hard drive.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

> I have an asset database that I want to keep track of what user is entering
> new assets.  I need a way to ask who is about to use the database (possibly
[quoted text clipped - 5 lines]
>
> Bob
 
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.