 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / February 2005Table linking
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. > 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.