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 / Modules / DAO / VBA / September 2006

Tip: Looking for answers? Try searching our database.

Userid/Password Restrictions, Are there any?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Alex Kovalchuk - 28 Sep 2006 20:16 GMT
If you are storing the User Id and password in a table.

Is there any restrictions (like special characters?) that you cannot use?

Or does MS Access 2000 care?
Granny Spitz - 28 Sep 2006 21:52 GMT
> If you are storing the User Id and password in a table.
>
> Is there any restrictions (like special characters?) that you cannot use?

The restrictions are:

1)  The user name must be unique and cannot be NULL.  
2)  The password can be up to 255 unicode characters.
3)  You must implement User-level security on the database, remove read
design permissions on this table for the users, and create a RWOP query that
users can use to authenticate.

Oh wait, hon ... since you have to implement security anyway to protect the
table from curious eyes, why not just use the CurrentUser function to
determine who the current user is?  If they opened the secure database, then
they must have used the correct password, so there's no need to store the
user name and password in a table, eh?
 
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.