If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trouble with split database
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 |
#2
|
|||
|
|||
Trouble with split database
On Fri, 29 Jan 2010 15:01:01 -0800, oldblindpew
wrote: 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! :-{( -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Trouble with split database
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" wrote: On Fri, 29 Jan 2010 15:01:01 -0800, oldblindpew wrote: 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! :-{( -- John W. Vinson [MVP] . |
#4
|
|||
|
|||
Trouble with split database
On Mon, 1 Feb 2010 08:51:01 -0800, oldblindpew
wrote: 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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|