Creating a linked table when you do not have Admin privileges.

[Mark Maeker]

I have a secured database (mdb) running in Access 2007. The following
statement works if I am logged into an account with Admin privileges, but it
does not work for a non-Admin account.

DoCmd.TransferDatabase acLink, "dBase IV", fol, acTable, fil.Name, "tblImport"

The non-Admin user gets error number: 3111 which states "Could not create;
no modify design permission for the table or query 'tblImport'."

In testing, I have tried to link to an Excel spreadsheet, using the toolbar
while I am logged in a as non-Admin user. This test failed.
Please help,

 

[Clifford Bass]

Hi Mark,

Have you given the non-Admin design permission? Adding a table link
would be considered changing the design of the database. I presume that that
is not allowed by default for non-Admin users.

Clifford Bass

 

[Mark Maeker]

Hi Clifford,

It appears that I must use Microsoft's Full Permission group and modify the
setting to limit the permissions to those I need. I tried to create my own
group, so that I could choose the group name. I believe that I set every
visible setting on my group to match that of the Full Permission group, but
my "Import Users" group would not work.

Thanks for the response,

Mark