Trouble with split database

[oldblindpew]

Where do I begin...

I added a new table to my frontend database, forgetting that it was split.
I then copied the table into my backend database and tried to use the Linked
Table Manager to refresh the links. I've had trouble with the Linked Table
Manager before, as it never seems to work as expected.

I was never able to get the tables linked, so eventually the only thing I
could see to do was try resplitting the database using the Wizard. After
all, it's a point and click world. This worked really smoothly, except it
apparently allowed me to effortlessly wipe out all the data in my backend
database. If nothing else, I want to post a warning to others that this
thing is a menace.

My next step was to restore my backend from yesterday's backup by copying it
over the old corrupted backend, and using the Linked Table Manager to refresh
the links. Maybe it wasn't necessary to refresh the links, but my
applications seems to be working again.

I still don't know how to add the new table to my backend database. This is
another subject not addressed in any of my reference books. And now, the
table is missing from the frontend too, though it is still listed as an
object. When I try to open it, I get the error message that the Access db
engine cannot find the input table.

Thanks for any help,
OldBlindPew

 

[John W. Vinson]

I still don't know how to add the new table to my backend database.

Open the backend database directly, by itself, not as a linked database. Add
the table (in the table design view, or by importing a Table not a link).

You'll then want to go to the frontend, *delete all the links*, and use
File... Get External Data... Link to link to the corrected backend.

Sorry you had so much hassle with the Linked Table Manager, and hope that you
had a good backup... that does NOT sound like a fun day! :-{(

 

[oldblindpew]

Thanks, John.
It took a bit of research for me to learn that deleting the links in the
frontend database means deleting the linked tables entirely, an idea that
took some getting used to. After that, it was all easy.

 

[John W. Vinson]

Thanks, John.
It took a bit of research for me to learn that deleting the links in the
frontend database means deleting the linked tables entirely, an idea that
took some getting used to. After that, it was all easy.

Pretty scary... select a table, press the Delete key, and answer Yes to that
ominous question...!

But yes, it works fine.