Copy Table in Access 2007

Gberndt
Gberndt used Ask the Experts™
on
I have a table in Access 2007 that I just want to Copy and paste to make a second Table to test.  When I do a copy and paste some of the tables copy but most of the tables give me an error Operation is not supported for this type of object.

I don't want people to quess and have me try things.  I would like to have a answer from someone that has ran into this problem.

Thanks in advance

Greg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2006

Commented:
It depends. Tables with Foreign keys require external tables to support the configuration.

Try using a query instead

SELECT * FROM YourTable INTO YourNewTable

J

Author

Commented:
I took out all of the fields but one to see if it was something wierd.  It does not have a key in the table.  Nothing is linked.  Just don't understand why some of the tables copy, but others don't
Top Expert 2006

Commented:
<<I don't want people to quess and have me try things>>

This kind of thing is mostly frowned upon. You will likely have to help us narrow down the issue. By "Us" having you "Try" things, we are able to narrow down a problem that is likely unique to you.

Just my .02

J
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Author

Commented:
I did do a make table and it will create a new table.  But I should be able to do a copy and paste.  Also should be able to drag from another database a drop a table into the database and it wont do that either.
trying to figure out if this is an MS access issue or maybe an issue with my company computers.
Top Expert 2006

Commented:
What's the error when you drag and it fails?

My experience with dragging into a database and it fails is I've not compiled the code, or I've got an object open in design view and the "Import" fails.

I have not had the same issue with a copy and paste, even with large tables, even link tables.

There are some limits with Access. The number of objects, the size, etc...I assume you know these and have already ruled them out.

If some work, and others do not, is there a pattern? Do the successful tables all have a unique ID? and the failed ones do not? Are there Memo fields or Image fields involved?

Author

Commented:
I did compact and repair the database, I also converted it into a 2007.  Atother person that has 2003 can copy and paste the table in the same database that I use.  We tested another 2007 user and it fails on his machine also.
Top Expert 2006
Commented:
I'll point some other experts here to see if they too have had similar experiences. I think there's enough info here now so that if someone else has experienced this, then it will be clear.
Hang in there.

J

Commented:
I can tell you from experience in A2003 if you click a table to highlight it, press Ctl+C, then Ctl+V, you will get a dialog box that asks you for a new table name and whether you want structure, or structure + data, or append data to existing table - just so you know the lineage of the action.
mbizupNerd
Most Valuable Expert 2012
Top Expert 2013

Commented:
Gberndt,

Can you post a sample (no sensitive/personal data) containing a couple of tables that give you this trouble?  If this is an .accdb file, just rename the extension to .txt before uploading it.
Commented:
It seems like for some reason that the database must have corrupted some of the table and the compact and repair would not fix.  When I would do a make table of the bad table, I could take the new table and copy and paste the data.  I thank you all for the help.

Greg

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial