P
Peter Kinsman
I have already posted this in the TechNet Terminal Services area, but
received no reply. I suspect the answer is more Access related than
Terminal Services related so here goes!
I am building an Access database which among other things will create and
update Bills of Materials. This involved temporary tables, to display the
workings on the screen. The permanent tables are in a separate database.
In a normal environment, each user would have their own copy of the
temporary files, but running under Terminal Services, this is presumably not
the case, so I need to keep each user's records separate.
I have started by using a RunNumber, which is updated each time a User opens
the program. This is then used as an extra field on the temporary table.
It works in the two instances I have updated, but is very tedious to
install.
Another solution - similar to that used in the IBM midrange environment from
which I come - would be to create a temporary table whose name incorporated
the Run Number, but that would mean creating temporary queries as well.
Is there an established method of doing this when running under Terminal
Services please?
Many thanks
Peter Kinsman
received no reply. I suspect the answer is more Access related than
Terminal Services related so here goes!
I am building an Access database which among other things will create and
update Bills of Materials. This involved temporary tables, to display the
workings on the screen. The permanent tables are in a separate database.
In a normal environment, each user would have their own copy of the
temporary files, but running under Terminal Services, this is presumably not
the case, so I need to keep each user's records separate.
I have started by using a RunNumber, which is updated each time a User opens
the program. This is then used as an extra field on the temporary table.
It works in the two instances I have updated, but is very tedious to
install.
Another solution - similar to that used in the IBM midrange environment from
which I come - would be to create a temporary table whose name incorporated
the Run Number, but that would mean creating temporary queries as well.
Is there an established method of doing this when running under Terminal
Services please?
Many thanks
Peter Kinsman