P
Pendragon
I have a single program file on the front end and five separate data files on
the back end (each is a separate client's data). I've discovered that after
relinking tables to a different data file, my program file size is increasing
dramatically and all my forms, queries, reports, etc. take much longer to
run/load.
What is going on in the relinking of tables that would cause this, and is
there a way to resolve the issue without having to compact & repair my
program file every time I need to change data files?
FYI - I do have two forms that are open and hidden during the relinking
process. One is a simple form that keeps the company's basic data and the
other form is my Main Switchboard of the program file.
Thanks for any help!
Ross
the back end (each is a separate client's data). I've discovered that after
relinking tables to a different data file, my program file size is increasing
dramatically and all my forms, queries, reports, etc. take much longer to
run/load.
What is going on in the relinking of tables that would cause this, and is
there a way to resolve the issue without having to compact & repair my
program file every time I need to change data files?
FYI - I do have two forms that are open and hidden during the relinking
process. One is a simple form that keeps the company's basic data and the
other form is my Main Switchboard of the program file.
Thanks for any help!
Ross