Access 2000 security

  • Thread starter Thread starter E. Alan Jankovic
  • Start date Start date
E

E. Alan Jankovic

I have a situation where on 4 occasions a user's security
permissions on a table (created by a make table query) are
dropped. Before beining dropped she has all permissions,
which seems to be necessary to execute a make table query.

The user is in the full data users workgroup.
 
A make table query creates a new table. She'll get permissions that are
assigned to the <New Tables/Queries> object.

Perhaps you could run a delete query and an append query, rather than
recreating the table.
 
Back
Top