HELP - From WHERE, WHY and WHAT is TMPSRnnn.db???


I recently created a new process using Pdox 9 ? Windows XP SP2
with a bunch of PRIV tables and 1 WORK table.
During the test I gave a Test User FULL CONTROL to my folder
so that User could enter data and troubleshoot the new process.

Now that I have moved the process to Production
a TMPSRnnn.db is created when a User (and not me) runs the process.
The Users that are allowed to use the App in Production are in a Group.
I now see that the Group has permissions:
Read & Execute
List Folder
Read
Write

While watching Shark last night I had ?a moment of brilliance? and thought
that maybe I should add MODIFY Permission to the Production table so that
the Users can sort the table and eliminate the creation of the TMPSRnnn.db
table !
Bad Idea. :(
Not only was the TMPSRnnn.db created but the Production table was DELETED!

There are no other processes in Production where the User sorts a Production
Table - keys/index will not work for the new process... well they probably
will if I worked at it ? but for now I need to find out about the TMPSRnnn.db
table that?s created and move on and maybe get back to this process sometime
in the future to implement keys/index ?

1. My in-house Admin Staff has never heard of TMPSRnnn.db tables
2. Is my thinking correct about WHY TMPSRnnn.db table is created?
3. Did the addition of the MODIFY Permission cause the deletion of the production
table?
4. If I give Full Control to this one table what can the Users do that they
are unable to do with the other tables in Production?

TIA

Jeanette



.

Relevant Pages

  • Re: HELP - From WHERE, WHY and WHAT is TMPSRnnn.db???
    ... The Users that are allowed to use the App in Production are in a Group. ... There are no other processes in Production where the User sorts a ... Table - keys/index will not work for the new process... ... Did the addition of the MODIFY Permission cause the deletion of the ...
    (comp.databases.paradox)
  • Re: HELP - From WHERE, WHY and WHAT is TMPSRnnn.db???
    ... the production area will be filled up with unneeded data SINCE they are ... Now that I have moved the process to Production ... Table - keys/index will not work for the new process... ... Did the addition of the MODIFY Permission cause the deletion of the ...
    (comp.databases.paradox)