Linked Table Manager and Permissions Problem

T

tbl

In a split and secured Access 2000 db (managed under Access
2002), a user with admin permissions can use the Linked
Table Manager (LTM) and not have problems with it.

I've given my custom group "Field Admins" permissions to
everything except Admin for all objects, in both ends, but
when I try to use the LTM under a Field Admins account, it
gets to the last step, and then comes up with:

"Could not create: no modify design permission for table or
query 'TMP%#MAU@'." I have no table by that name, or
anything close.

Then, when I try to close the db, I get:

Could not create; no modify design permission for table or
query 'TempMSysAccessObjects'.

This problem has persisted thru the OS change from Win2k to
WinXP.

Anyone here care to offer any suggestions?
 
S

SteveM

The tables you have been notified of are most likely hidden system tables.
To do this kind of modification, you will probaly need create table rights
or something similar...

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top