View Single Post
  #2  
Old January 29th, 2010, 11:41 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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]