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 / May 2008

Tip: Looking for answers? Try searching our database.

real multi users

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Souris - 23 Apr 2008 14:09 GMT
I would like to creat multi users for my applications.

Are there any link or example to show me how create multi users ID and
password?

Your hlelp is great appreciated,
Larry Linson - 09 May 2008 08:17 GMT
>I would like to creat multi users for my applications.
>
> Are there any link or example to show me how create multi users ID and
> password?

You don't "create" multi users -- Access is multi-user enabled right out of
the box.

You can improve multi-user reliability and performance.  My first suggestion
is always this: "Split the front end (queries, forms, reports, macros, and
modules) from the back end (tables, relationships, and data). Give each user
a copy of the front-end database, linked to the tables in the back end,
which is stored in a shared folder on a machine in the LAN.  You can use the
Linked Table Manager, or write your own code, to link the tables."

Then I advise visiting MVP Tony Toews' site
http://www.granite.ab.ca/accsmstr.htm, for other good tips and hints on
avoiding corruption and performance.

There are some situations in which you want "protection", in which case I
advise going to the Knowledge Base at http://support.microsoft.com and
searching for Security FAQ for Access.  It's 30 pages with no filler at all,
so read it carefully.  Alternatively, if you are just trying to identify
who's making updates, you can see the API section at
http://www.mvps.org/access and retrieve a windows logon name.  If you are
developing in Access 2007 ACCDB, the Access workgroup or user-level security
is not supported and you'll have to "roll your own" security.

Larry Linson
Microsoft Office Access MVP

Rate this thread:






 
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.