Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why do users require permission to create new tables in the destination database in order to update a table attachment?

April 26, 2017create database destination permission require tables Users

0

Posted

Why do users require permission to create new tables in the destination database in order to update a table attachment?

1 Answer

0

Posted

Even if you are only refreshing an existing link, Microsoft Access still treats the attachment as if you were creating a new table. When you set permissions for tables, the setting refers to permissions a specific group or user will inherit when a new table is created and has nothing to do with revoking the ability to create tables in the first place. You can’t remove permission to create new tables in the user interface-you have to do it from code as shown in Section 18, “How can I help prevent users from creating new objects in my database?”. Microsoft Access 2.0: The Security Wizard presents a check box that will exclude this ability from the existing users and groups. If you select this option at the time that you run the Security Wizard, then only members of the Admins group will be able to create new tables and queries. This makes it impossible for any user not in the Admins group to create new links. Microsoft Access 95 Microsoft Access 97 and Microsoft Access 2000: