Hi Sono,
1. I logod on as a new user and tried to insert data but it won't let me.
Check the permissions of the User account that you are logged in as
2. Back end of my DB is located on a network drive on a Server and I
changed the security level on the server as well. But my users can still
logon as usual and insert/delete data. How I can make shortcuts to my users
from the new secured DB.
Are you saying that you changed the User Level security on the Backend
database? Your users are probably not using the correct WorkGroup
Information File (*.mdw) thereby they are coming in as the Admin account
which is still probably a member of the Admins group.
3. How I can undo (no security at all), if it goes wrong?
Here you go:
1. Join the workgroup information file (*.mdw) using Workgroup Administrator
(wrkgadm.exe) that defines security for the database that is secured.
2. Open the database you wish to unsecure using the logon that defines Admin
privileges for the database (not necessarily Admin).
3. Grant full permissions to the Users group and the Admin user account for
all
objects in the database. Change the owner of all objects in the database
to
be the Admin user.
4. Quit Microsoft Access
5. Start Microsoft Access and open the secured database you wish to unsecure
using the Admin logon user name.
6. Create a new, blank database named UnsecureStep1.mdb.
7. Select Tools --> Security --> User and Group Permissions from the menu.
8. On the Permissions tab, select Database from the Object Type combo-box.
9. On the Permissions tab confirm that the Admin user and Users group have
full
permissions (Administer) on the <Current Database> Object Name.
10. On the Permissions tab, select Table from the Object Type combo-box.
11. On the Permissions tab confirm that the Admin user and Users group have
full permissions on the <New Object> Object Name.
12. Repeat Steps 10 and 11 for each Object Type: Query, Form, Report, Macro
13. Select the Change Owner tab.
14. Select Database from the Object Type combo-box and confirm that Admin is
the Current Owner of the database and click OK. If not, close the database
and start fresh at Step 1.
15. Select File --> Get External Data --> Import from the menu.
16. Browse to the secured database and import all of the objects into the
blank
database.
At this point, you will have a database that is currently in an unsecured
state
(UnsecureStep1.mdb) but still associated with the workgroup information
file
that defines security for all databases.
17. Quit Microsoft Access
18. Join or create a default workgroup information file using Workgroup
Administrator (wrkgadm.exe).
19. Start Microsoft Access.
20. Create a new, blank database named UnsecureStep2.mdb.
21. Select File --> Get External Data --> Import from the menu.
22. Browse to the UnsecureStep1.mdb database and import all of the objects
into
the blank database.
You now have a database that is unsecured and associated with a default
workgroup information file (UnsecureStep2.mdb).
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<
http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <
http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
This posting is provided "AS IS" with no warranties, and confers no rights
--------------------
| Content-Class: urn:content-classes:message
| From: "Sono" <
[email protected]>
| Sender: "Sono" <
[email protected]>
| Subject: user security
| Date: Wed, 4 Aug 2004 10:03:42 -0700
| Lines: 16
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcR6RP7QuhtRwsFkRGWP06wMXj3i4A==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:12587
| NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
| X-Tomcat-NG: microsoft.public.access.security
|
| Access 2000:
| I have a splitted DB (front and back end) on my network. I
| created New User accounts for my users and I made only one
| table secured. If I understood correctly, this New User
| account can insert data but cannot delete or edit right?
| So here're the problems I'm facing:
| 1. I logod on as a new user and tried to insert data but
| it won't let me.
| 2. Back end of my DB is located on a network drive on a
| Server and I changed the security level on the server as
| well. But my users can still logon as usual and
| insert/delete data. How I can make shortcuts to my users
| from the new secured DB.
| 3. How I can undo (no security at all), if it goes wrong?
| sorry for the long message...
| cheers,
|
