Re: TMP%#MAU@ problem
- From: "Joan Wild" <jwild@xxxxxxxxxxxxxxxx>
- Date: Sat, 2 Feb 2008 11:06:11 -0500
See DbUtilities 1.0 at http://www.accessmvp.com/SDaigle/index.htm for sample code.
--
Joan Wild
Microsoft Access MVP
"Paul" <Paul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:3BB24AA2-4B82-4A8D-B71B-B9C3ABC24903@xxxxxxxxxxxxxxxx
HI!.
I have a FE/BE solution with Access 2002. Every once in a while I like to
import into a blank database to clean things up. After the import I manually
set permissions on all objects, a tedious process, so I thought I would do it
in code by going through the Containers and Documents. All looked pretty good
until I tried to relink to a different BE. I have a dedicated user 'Owner'
that has necessary persmissions to do this, or so I thought. When I try to
relink by setting permissions in code, I get: error 3111, could not create:
no modify design permission for table or query TEMP%#MAU@. I dont' have this
problem if I set permissions manually???
This must be some sort of internal or temporary table that I have access to,
so I can't figure out how to debug this. I dumped all documents for 'Owner'
and this table doesn't show anywhere.
Any help would greatly be appreciated.
Thank You.
Paul
- Prev by Date: Re: want to be done with workgroup files and user level security
- Next by Date: Re: want to be done with workgroup files and user level security
- Previous by thread: Re: want to be done with workgroup files and user level security
- Next by thread: Re: Access Front End with Excel Back End
- Index(es):
Relevant Pages
|
