Any use of linking data, in a non-network environ?

[ahvc]

Dear All,
Is there any advantage to link MS-Access to another MS-Access Database though linking. I know it has many benefits in a multi-user /network environment. But in a small application or single user environment, does it have any use? Please let me know.

Thank you very much
VC

 

[Fizzio]

One distinct advantage is if you make small changes to forms, queries etc, is that it is easier to update a remote copy. Also it minimises Db Bloat (if you make multiple small changes, your Db can increase in size a lot and therefore slow down). Also if you ever do think about expanding, you already have the structure to allow it.
On the downside, you have to hard link the tables and check that the links are complete if you do make any changes or use VBA to check the links for you and also maintain 2 Db instead of one.

HTH