[AccessD] Re: Temp tables and access security

Thanks Robert

Mark

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert L.
Stewart
Sent: 27 January 2004 19:28
To: accessd at databaseadvisors.com
Subject: [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


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com