Security FAQ > TableDef (?)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tbl - 26 Jun 2007 23:25 GMT

In the Security FAQ, Section 14, it mentions that you "need
to have Read Data permissions on the TableDef object in the
source database" to refresh existing table attachments.

What is the "TableDef" object, and how do I set the
permissions for it?

By "source database", is the author referring to the
back-end tables?

Signature

Thanks
tbl

Reply to this Message

Scott McDaniel - 27 Jun 2007 12:10 GMT

>In the Security FAQ, Section 14, it mentions that you "need
>to have Read Data permissions on the TableDef object in the
>source database" to refresh existing table attachments.
>
>What is the "TableDef" object, and how do I set the
>permissions for it?

A "TableDef" is just a table; the DAO object for a table is known as a TableDef, and if needed, you would
programatically manipulate permissions on the "TableDef" object.

>By "source database", is the author referring to the
>back-end tables?

Yes. You'd set those perms in the backend (make sure to use the same workgroup file to secure both the backend and
frontend).

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

Reply to this Message

tbl - 27 Jun 2007 16:07 GMT

>>In the Security FAQ, Section 14, it mentions that you "need
>>to have Read Data permissions on the TableDef object in the
[quoted text clipped - 12 lines]
>workgroup file to secure both the backend and
>frontend).

Thanks Scott.

I've been trying to understand why our satellite office
can't use the Linked Table Manager when they try to put the
back-end on the LAN and the front end on a couple of
workstations.

This is an Access 2000 mdb used on Access 2002 machines,
under Win2k.

After reading thru the FAQ, it seemed like the "Field
Admins" group should be able to use the linked table
manager, but the FAQ is not very clear on this (to my little
brain). But maybe the FAQ is saying that to have the tables
secured, and *still* allow limited users to use the Linked
Table Manager, coding is needed. I'm not a coder, so the
coding offered would have to be good-to-go as is, or I'd be
sunk.

I've gone so far as to give the "Field Admins" open/run
permissions on the back-end db, and all permissions except
Administer on the tables, queries, forms, reports, and
macros, but still they can't use the LTM, and I don't know
why. Access knows, but it won't tell me! ;-l

Thanks again for your reply.

Signature

tbl

Reply to this Message

Scott McDaniel - 27 Jun 2007 17:58 GMT

>>>In the Security FAQ, Section 14, it mentions that you "need
>>>to have Read Data permissions on the TableDef object in the
[quoted text clipped - 37 lines]
>macros, but still they can't use the LTM, and I don't know
>why. Access knows, but it won't tell me! ;-l

Have you given the group the same permissions for NEW tabledefs (i.e the <Net Tables/Queries> selection on the Object
Name listing, in the User and Group Permissions dialog)? I'm not sure, but the LTM may destroy and then re-create the
links ...

Alternatively, you can roll your own LTM. Basically you'd (a) determine what tables need to be relinked (generally done
by storing those values in a table somewhere), (b) run code to either refresh or rebuild the link. See here for more
info:

http://www.mvps.org/access/tables/tbl0009.htm

>Thanks again for your reply.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

Reply to this Message