Quote Originally Posted by Djblois
If I inputed a table from Oracle into Access would it delete the table from Oracle or just create a copy?
In the copy of your database, delete the link to your Oracle table. Then chose "File -> Get External Data -> Import" from Access' menu to create a Jet copy of the Oracle table.

If it doesn't work for you as I described, give me some details about how you're linking from Access to Oracle. We can probably figure out an alternative.

Hans