I suppose you could write a procedure that fires on the startup of the ms
Access Db to
point the user to another tablespace. Or what about a trigger on logon of
this user?

Bastien

----- Original Message -----
From: "Johnson, Shaunn" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, February 26, 2004 12:27 PM
Subject: silly tablespace question


> I know this is a Microsoft question, but I can't
> find anything useful in groups.google.com.
> I'm trying to look into the MS list now ...
>
> Is it possible for MS Access users change the
> tablespace they create data on within the
> MS Access program?
>
> I have a tablespace that is filling up and I need
> to move things around. While I can not do anything
> about the SCHEMA right now, I need to have the
> users who connects to the database (Oracle 9i)
> to connect to the same schema, but build their tables
> into different tablespaces.
>
> Is this possible?
>
> Thanks!
>
> -X
>


Oracle LazyDBA home page