Work tables in multi-user database

[Peter Kinsman]

I am working on a multi-user database which includes Bill of Material forms.
The main tables are linked to a "Tables" database, but the subform on each
of the Bill of Material forms are bound to a local table. The problem is
that the network uses Terminal Services, so there is only one copy of the
program, so Bill of Material maintenance becomes a single-user activity. As
long as I use record locking at the assembly level, is there a way to have
multiple work files? I suppose I could cheat by including the assemble code
in the table name.

Any suggestions please?

Many thanks

Peter Kinsman

 

[Roger Carlson]

One thing I've done: On opening the database (or the main form, actually)
the database creates a temporary database in the user's private directory.
Then it exports blank copies of the work tables and links them back into the
database. When the database closes, it deletes the temporary database.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ImportToTempDatabase.mdb" which illustrates how to do this.
The only parts of the sample applicable to your situation is the
basCreateDatabase module, the main form which launches it, and the table to
export. The sample creates the temp table in the same directory as the
database, but you can change that to specify any directory.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Peter Kinsman]

Roger

Thanks for the suggestion. Unfortunately there are no private folders on
the server, but I could always create a database using the all or part of
the User's name and then do a TransferDatabase into that. Alternatively, I
was wondering whether to add the Assembly Record_ID as a field on the single
table and then filter the data. Maybe over the Christmas break!

Peter