View Single Post
  #1  
Old January 29th, 2010, 11:01 PM posted to microsoft.public.access.tablesdbdesign
oldblindpew
external usenet poster
 
Posts: 128
Default 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