Reports from my temporary table

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have a LAN based Access 2002 database.
I create a temporary table that users print reports from.
The user sets up a make-table-query to put data in the table.
It works fine when there is only one user on the database.
When several users are on at the same time, the table has
info from the last way it was created which may not be the
way others want it.
How can each user have his own table but use the common reports?
 
The usual way to handle a multiuser Access - Jet database engine database is
to give each user his/her own "front end" DB (queries, forms, reports,
macros, modules, and any local tables -- like your temporary table, for
example). MVP Tony Toews has an example on his website of creating a
temporary database to contain the temporary table -- when done, you delete
the temporary database and avoid problems of database bloat due to
unrecovered memory.

From your description, almost certainly, all the users are sharing a
front-end as well as a back-end, or an unsplit, monolithic database.

Larry Linson
Microsoft Access MVP
 
David said:
I have a LAN based Access 2002 database.
I create a temporary table that users print reports from.
The user sets up a make-table-query to put data in the table.
It works fine when there is only one user on the database.
When several users are on at the same time, the table has
info from the last way it was created which may not be the
way others want it.
How can each user have his own table but use the common reports?
Click to expand...


The temp table need to be on the local machine. To avoid
bloating the front end mdb, you should use a temp mdb file
for the temp table. See
http://www.granite.ab.ca/access/temptables.htm
 
Back
Top