1f61 Sikh Philosophy Network - View Single Post - SQL sentence for make table
View Single Post
  #9 (permalink)  
Old 28-Jul-2006, 08:19 AM
John Vinson's Avatar John Vinson
Guest
 
Posts: n/a
   
   
Re: SQL sentence for make table -- use CurrentDb.Execute

On 12 Jun 2006 22:48:36 -0700, "yaniv d" wrote:

>there is a simple way.but my problem for now is that i need to make it
>for a multi-user and that complicating the issue becaouse i need to
>make tables that will be attached for every user that will use it


Why?

What can you do with individual tables which cannot be done with a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11232-sql-sentence-for-make-table.html
select query, filtering on the UserID field (which you might need to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11232
add to your table)? Storing data (a user's identity) in a tablename is
probably a Very Bad Idea.

Or, could you use a split database, with the source table in the
backend, and the individual tables in each user's frontend .mdb file?

John W. Vinson[MVP]
Reply With Quote
 
Page generated in 0.12971 seconds with 25 queries
0