Hi Johnson,

there are two ways of solving the problem

1) add some datafiles to yr existing tablespace, so that the same users can contnue to write the data into

2) shift some fo the users to other tablespace, so that this present one can accomodate rest of the users

please correct me if am wrong, in MS Access upto year 2000 there wasn't tablespace concept, where database/database file was there i.e. say johnson.mdb, a user can put/change his data into.

yes, In SQL SERVER there was/is

refer docs for syntex on creating tables in diff tbs, you need to give such grants for user..

good luck..subodh deshpande

--------- Original Message ---------

DATE: Thu, 26 Feb 2004 12:27:25
From: "Johnson, Shaunn" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed]

>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
>



____________________________________________________________
Find what you are looking for with the Lycos Yellow Pages
http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10
Oracle LazyDBA home page