Table linking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a multi-user Access 2000 database, used for reporting only. Tables are
linked to folders according to year, ie DATA2004 & DATA2005. Each user will
enter the year he requires.

I know how to refresh the links programmatically but how can I do this for
each user? E.g. user1 needs to link to DATA2004 at the same time as user2
wants DATA2005.

For various reasons users can not have their own copy of the database.
Any suggestions will be much appreciated.
 
Akw said:
For various reasons users can not have their own copy of the database.

This is a recipe fopr disaster! Corruption may be a few blocks away or
just around the corner (more likely), but it's definitely coming your
way. Split the database to a front and, apparently, two back ends, give
each user their own, private copy of the FE (commonly on their local
HDD) and make the link changes through code within each user's local FE.

HTH,
Nikos
 
Back
Top