Table linking

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.
 
N

Nikos Yannacopoulos

Akw said:
For various reasons users can not have their own copy of the database.
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multi-user database 4
Programmatically creating a linked table 2
Linking Backend MDB Tables Programmatically 2
Diplaying rows into columns 1
Combine seperate rows into single column 1
Join multiple rows into columns 4
Dynamic table linking to different geograpic db with same tables 2
Locking Current Record 2

Top