multi-user database

[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 CANNOT have their own copy of the database, ie the
standard frontend/backend design.

Any suggestions will be much appreciated.

 

[Chris2]

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 freely admit my ignorance. Can someone enlighten me as to how to
link a Table to a Folder?


Sincerely,

Chris O.

 

[Lynn Trapp]

Begin by redesigning your database. It is NOT a good idea to have separate
tables for different years. Add a date field to your table and then give all
the users a form that is based on a query that filters the data based on the
appropriate year.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Guest]

Lynn,

Thank you for your reply.

The data is created by a separate package, which stores tables for each year
in its own folder, e.g. DATA2004,DATA2005 and each contains:
Courses.dbf, Students.dbf, Log.dbf, Codes.dbf & many others. I have linked
the tables for 2004 to my report database.

I have several reports, currently running with this 2004 data, and each with
its own query as the datasource. Each query will use a different combination
of related tables but most will use precisely these 4.

I want to link the tables for other years also. So linking from the
DATA2005 directory will initially give me:
Courses1.dbf, Students1.dbf etc., Access automatically adding the suffixes.


So how do I get my set of queries/reports to look at either
Courses.dbf/Students.dbf etc or Courses1.dbf/Students1.dbf etc depending on
the year selected by the user? Or must I have a separate set of
queries/reports for each year?

 

[Lynn Trapp]

Well, if you are stuck with that design, then you will need to create a
separate query for each year and, then, modify the recordsource of your
reports depending on the appropriate year.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html