[AccessD] Re: Temp tables and access security

Mark,

I would suggest using static tables in the front-end.  You will need to 
give the users all permissions except permission to delete and create 
tables.  You can do this if the structure of the temp tables do not change 
each time they are run.  You just truncate (delete all rows) in them and 
then reload the data.

Since I refuse to deal with Access security and I always have a copy of the 
program MDE on each client, this is the way I handle it.  I also have them 
refresh the local copy at least once a week.

Robert

At 12:03 PM 1/27/2004 -0600, you wrote:
>Date: Tue, 27 Jan 2004 00:01:59 -0000
>From: "MarkH" <lists at theopg.com>
>Subject: RE: [AccessD] Temp tables and access security
>To: "'Access Developers discussion and problem solving'"
>         <accessd at databaseadvisors.com>
>Message-ID: <000001c3e468$c9895c20$b00d6bd5 at netboxxp>
>Content-Type: text/plain;       charset="us-ascii"
>
>Sorry Charlotte, should have said "Access BE and FE", temp tables are in
>the front-end. I can chamge the code to not use temp tables, but I'd
>rather leave it alone as it works fine (at the moment :@)
>
>Many thanks
>
>Mark
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
>Foust
>Sent: 26 January 2004 19:45
>To: Access Developers discussion and problem solving
>Subject: RE: [AccessD] Temp tables and access security
>
>
>Why would a user be creating temp tables in the BE?  Normally temp
>tables would be created in the front end.  Are you asking about Access
>security permissions or Windows permissions?  In Windows, you need
>pretty much full permissions if you're going to be modifying the design
>of the BE.
>
>Charlotte Foust
>
>-----Original Message-----
>From: MarkH [mailto:lists at theopg.com]
>Sent: Monday, January 26, 2004 11:30 AM
>To: 'Access Developers discussion and problem solving'
>Subject: [AccessD] Temp tables and access security
>
>
>Hello All
>
>Using AXP on Win 2000
>
>I have a secured database and was wondering what permissions I need to
>grant to allow the system to create temp tables (Access BE) when a user
>logs in. I'm missing something I reckon...
>
>Cheers
>
>Mark