RE: Security setup does not allow import of tables

From: Eric Butts [MSFT] (ebutts_at_online.microsoft.com)
Date: 05/09/04 

Date: Sun, 09 May 2004 23:20:42 GMT

Hi,

When you click on the menu option Tools > Security > User and Group
Permissions at the bottom of the screen does it show you logged in as the
user in Step#4?

Select the Change Owner tab. Who does it show for the owner of those
tables you can't import? Can you change the owner?

Regards,

Eric Butts
Microsoft Access Support
ebutts@online.microsoft.com
"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

--------------------
| From: hamilton_allstrong@yahoo.com (hamking)
| Newsgroups: microsoft.public.access.security
| Subject: Security setup does not allow import of tables
| Date: 7 May 2004 12:43:36 -0700
| Organization: http://groups.google.com
| Lines: 62
| Message-ID: <18aed688.0405071143.94d51b8@posting.google.com>
| NNTP-Posting-Host: 216.59.132.114
| Content-Type: text/plain; charset=ISO-8859-1
| Content-Transfer-Encoding: 8bit
| X-Trace: posting.google.com 1083959016 31152 127.0.0.1 (7 May 2004
19:43:36 GMT)
| X-Complaints-To: groups-abuse@google.com
| NNTP-Posting-Date: Fri, 7 May 2004 19:43:36 +0000 (UTC)
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!p
ostnews1.google.com!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.security:10569
| X-Tomcat-NG: microsoft.public.access.security
|
| I've tried setting up an access database using the following steps
| described below from Microsoft's knowledge base:
|
| http://support.microsoft.com/support/kb/articles/q254/3/72.asp
|
| The steps as described below:
|
| 1. Open the Workgroup Administrator (Wrkgadm.exe) file and create a
| new system database (System.mdw) that has a unique Name, Organization,
| and Workgroup ID.
| 2. Start Microsoft Access and open any database.
| 3. On the Tools menu, point to Security, and then click User and Group
| Accounts. Click the Change Logon Password tab, assign a password to
| the Admin user account, and then click Apply.
| 4. In the User and Group Accounts dialog box, click the Users tab.
| Create a new user account, and then add the account to the Admins
| group.
| 5. In the Name box under User, click Admin. Remove the Admin account
| from the Admins group, and then click OK.
| 6. On the File menu, click Exit. Restart Microsoft Access.
| 7. Create a new database.
|
| After you have named the new database, and then clicked OK, the Logon
| screen appears.
|
| Note that this is different from earlier versions of Access, where the
| Logon screen appears before Access starts.
| 8. Type the name of the user that you created in step 4. Leave the
| password blank.
| 9. On the Tools menu, point to Security, and then click User and Group
| Accounts.
| 10. Click the Change Logon Password tab, type a password, and then
| click OK.
| 11. On the Tools menu, point to Security, and then click User and
| Group Permissions. Click the Permissions tab, and then click to select
| Groups under the List options to display the group names in the
| User/Group Name box.
| 12. In the User/Group Name box, click Users. Select the appropriate
| object type in the Object Type box to display the various objects in
| the Object Name box, and then remove the default Users group
| permissions for the following objects that appear in the Object Name
| box:
| <Current Database>
| <New Tables/Queries>
| <New Forms>
| <New Reports>
| <New Macros>
|
| 13. Import all the objects from your original database into the new
| database.
| 14. Create other group and user accounts as necessary.
| 15. Assign group and user permissions to your objects as appropriate.
| 16. Optional: Close the database, and then use the Encrypt/Decrypt
| Database command. To encrypt the database, click Tools, and then point
| to Security. This step is optional.
|
| I've completed all sthe steps up till #13. However, it will only
| allow me to import 3 of the 10 tables. The remaining 7 tables would
| not import because i do not have Read Design and Read Data
| permissions. However, checking the permissions for the user created
| in step #4 shows that it has all the permissions. Can anyone advise
| why this is?
|

Loading