[AccessD] Temp tables and access security

So were you asking about Access security or Window security on the file?

Charlotte Foust

-----Original Message-----
From: MarkH [mailto:lists at theopg.com] 
Sent: Monday, January 26, 2004 4:02 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Temp tables and access security


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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

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