Linking Tables

[SamDemon]

Hi All,

let me set the scene... every week 3 macros are run to empty all the records from the three notes tables that are >= 90 days old. The records are appened to another database (Archive) then deleted from the original. This has been done to try and keep the size of the database down.

The problem is now that my boss wants to see the records at the press of a button. What i have done is linked the notes tables back to the archive and created a command button on one of the forms which opens up the linked table.

My question is... now that the tables are linked am I not saving myself any space? Is there another way of doing this???

Thanks in advance.

Sam

Thanks in advance.

It's just common sense, shame sense isn't common!

 

[BTilson]

Are you just linking the tables or are you actually importing them? If you are linking them, then yes, you are still saving the space, because a linked table is basically a shortcut saying, "Look over in this other database for the data."

However, if you are importing them back into your database, then you aren't saving any space.

Brooks Tilson
Database Development
Tilson Machine, Inc.

 

[SamDemon]

Yeah, (File > Get Extrenal Data > Link Tables).

Another quick question, what would you class as a large size database, i.e. when does it get to large that it becomes slow??

Thanks

Sam

It's just common sense, shame sense isn't common!

 

[BTilson]

I can't answer that question too accurately because there are many factors that determine that. Database design, speed/memory of the system its running on, network design, etc etc, all contribute to a databases performance.

Our main database here where I work is many gigs in size, but it's running on it's own dedicated server, so it still runs reasonably fast.

Brooks Tilson
Database Development
Tilson Machine, Inc.