A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Trouble with split database



 
 
Thread Tools Display Modes
  #1  
Old January 30th, 2010, 12:01 AM 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
  #2  
Old January 30th, 2010, 12:41 AM 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]
  #3  
Old February 1st, 2010, 05:51 PM posted to microsoft.public.access.tablesdbdesign
oldblindpew
external usenet poster
 
Posts: 128
Default 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  
Old February 2nd, 2010, 12:01 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.