Newbie Help---can't copy table

[Guest]

I'm trying to copy a table and all it's data to another database. For some
reason, this one particular table won't copy and when I try, it shuts down
the database I'm attempting to copy it to. Any ideas as to why this would be
happening? FYI, db1 was designed by someone else. I made copies of the
tables and used those, but completey redid all the forms, etc., to make db2.
Five other tables copied fine to db2, but this one table won't. When I try
(in a variety of ways) I get the 'encountered a problem..shutting down'
message. Any help is much appreciated. I am done the project except for
this.

 

[Joseph Meehan]

I'm trying to copy a table and all it's data to another database.
For some reason, this one particular table won't copy and when I try,
it shuts down the database I'm attempting to copy it to. Any ideas
as to why this would be happening? FYI, db1 was designed by someone
else. I made copies of the tables and used those, but completey
redid all the forms, etc., to make db2. Five other tables copied fine
to db2, but this one table won't. When I try (in a variety of ways)
I get the 'encountered a problem..shutting down' message. Any help
is much appreciated. I am done the project except for this.

Just for fun, try making a copy of the original database file (MDB) and
store it safely away and do a compact and repair of the original file. You
might want to do the same to the target database file.

No bets on this one, but it sometimes helps strange problems.

 

[Guest]

Hi Newt,

Have you tried importing the table? Open db2, and try using File > Get
External Data > Import. If that fails, then chances are that something is
corrupt in the source table. You can try exporting the source table to a text
file, such as a comma separated variable (*.csv) file. If that is successful,
then try importing from this file.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Thank you for your suggestion Tom. Didn't work. Shut me down again, as did
Joseph's suggestion to 'compact and repair'.(thanks anyway Joseph) I'm
fairly certain there is a corruption as it was causing a problem in the
original database. Part of the reason I'm re-doing it . That, and it was
not at all user-friendly.
Is there any way to find out what the corruption is and fix it? What are
the usual corruptions in these instances?

 

[Guest]

Hi Newt,

Okay, time for Plan B. Try the suggestions that John Vinson and "69 Camaro"
(aka Gunny) gave to Julie in this recent thread:

http://www.microsoft.com/office/com...5d84bd-8d48-4f91-83e9-a8c47011b6a9&sloc=en-us

Is there any way to find out what the corruption is and fix it? What are
the usual corruptions in these instances?

I'm no expert in fixing corrupt JET databases, so I'm not even going to
offer a guess as to what the usual corruptions are. However, I will point you
to these two articles that should be required reading for all Access
developers:

Preventing Corruption (Allen Browne)
http://allenbrowne.com/ser-25.html

Corrupt Microsoft Access MDBs FAQ
http://www.granite.ab.ca/access/corruptmdbs.htm


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________