Microsoft Access Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsDatabaseMicrosoft Access Help
ASP Free and Iron Speed Designer are giving away $5,500+ in FREE licenses. Iron Speed's RAD CASE toolset can save up to 80% of your coding time. One free license per week, one perpetual license per month!

Download and Activate to enter!
Receive the tools necessary to be the rock star of your field. Our 12-month program teaches you the evolving world of multi-channel marketing as well as the complex issues and opportunities found in the industry.
Web development can be a daunting task, even for specialists. There is a lot of information to absorb and a lot of technologies to learn in order to manage a superior website. When trying to learn the ropes, developers need a reliable source to introduce new ideas that can be easily implemented. When working on large projects, even web veterans may run into a technology or an aspect of a technology that they are unfamiliar with.

Download to Enter | Contest Rules

Learn More!

Tutorials | Forums

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old February 5th, 2010, 11:38 AM
jimwest1 jimwest1 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jul 2009
Location: midwest
Posts: 4 jimwest1 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 32 m 25 sec
Reputation Power: 0
General - User level security and splitting databse

I have access database. I want to have user level security on it and split database- and have it on local network.
Do I install uls first or split?
I read if you split database - users can drag copy of front end to their desktops- does that mean they drag the front end database and shorcut created to log on?
If you already split database - and wanted user level security would you have to have it on both databases?
thank you
(access 2003)

Reply With Quote
  #2  
Old February 5th, 2010, 01:27 PM
don94403's Avatar
don94403 don94403 is offline
Contributing User
ASP Free Expert (3500 - 3999 posts)
 
Join Date: Jan 2007
Location: Northern California
Posts: 3,536 don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level) 
Time spent in forums: 4 Weeks 14 h 56 sec
Reputation Power: 761
Ordinarily you would secure only the back-end .mdb, since it is the data you usually need to protect.

I don't quite understand your question about dragging to the desktop. Possibly you are referring to a common practice where you create a desktop shortcut for the end users that calls your database with a command line parameter to use the appropriate .mdw workgroup file. This allows the users to use Access with other databases that don't require workgroup security (or possibly, use a different .mdw file). Read http://support.microsoft.com/kb/209207 under "option" look for "/wrkgrp".
__________________
Experience is the thing you have left when everything else is gone.

Reply With Quote
  #3  
Old February 5th, 2010, 01:53 PM
jimwest1 jimwest1 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jul 2009
Location: midwest
Posts: 4 jimwest1 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 32 m 25 sec
Reputation Power: 0
sorry to not be clear- when I create a database with user level security - the mdw short cut is created ( I use the the wizard)- I am not sure how you would access a user level secure database with out this shortcut- in that case I copy a short cut from local network to each user desktop-and that is how they access database- but now if I split a database and I have a front end database and a backend database- I am unsure how this shortcut mdw works with them?
thank you

Reply With Quote
  #4  
Old February 5th, 2010, 03:44 PM
don94403's Avatar
don94403 don94403 is offline
Contributing User
ASP Free Expert (3500 - 3999 posts)
 
Join Date: Jan 2007
Location: Northern California
Posts: 3,536 don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level)don94403 User rank is Major General (70000 - 90000 Reputation Level) 
Time spent in forums: 4 Weeks 14 h 56 sec
Reputation Power: 761
The default workgroup information file is "system.mdw", but you can have other such files, named anything you want (although that could become confusing). The 2 ways they can be used are:
  • Use the Workgroup Administrator feature (under Tools - Security) to "join" a workgroup by specifying the .mdw file to use. This would be done when an organization wants ALL their Access databases to be governed by the same workgroup permissions. In this case, you don't need to use a shortcut. Every time you open Access on that workstation, it will load that .mdw file.
  • Create a shortcut or simply use the Run command line to tell Access to use a particular .mdw file for the specific operation with a specific database. This is done when you want to let users work with other databases that are not governed by one common .mdw file.

You will have to decide which of these approaches meets your organization's needs. If you use the second approach (using desktop shortcuts), you shouldn't need to worry about securing the front-end.

Reply With Quote
  #5  
Old February 5th, 2010, 04:27 PM
jimwest1 jimwest1 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jul 2009
Location: midwest
Posts: 4 jimwest1 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 32 m 25 sec
Reputation Power: 0
thank you

Reply With Quote
Reply

Viewing: ASP Free ForumsDatabaseMicrosoft Access Help > General - User level security and splitting databse


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 



Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.

© 2003-2012 by Developer Shed. All rights reserved. DS Cluster 10 - Follow our Sitemap