In a post about an unrelated issue, I described the setup being used in
my workgroup, and was told that under TS each user should have their
own working copy in seperate folders. I am hoping to learn more. The
specifics:
****
Using an MS A2K front end running on WinXP and ODBC connections to SQL
Server 7 on Win 2K Server; there are about 10 users who access the
front end via Terminal Server and use the same front end; there are
about another 10 users who run a copy of the db on their local machine.
SQL server has 2 databases, with approx. 20 tables between them (one
is for processing ckts from a remote sql server for local use, the
other is a site database). We have been editing the tables directly.
****
Now that everyone is cringing...
I went to MS kb and didn't see any articles even generally hinting to a
problem running access on TS, with the exception of an unattended
system account running the db. I also didn't see many ts questions in
the ng with the exception of connecting accross a network.
When the TS users run the db, a copy of the mde is made in the same
directory, named as db1.mdb, db2.mdb, db3.mdb, etc. The only problem I
have had with this is that the copies are not removed when the users
close or logoff. In the 4 years my workgroup has worked like this,
noone has reported data loss or corruption that a source/cause was not
identified and corrected. (This is not to say that there has been
unreported data loss/corruption.)
Under what circumstances is data loss/corruption likely to occur?
Though the chances of users being in the same record is fair, the back
end server side locks at the column level seem to work quite well. Are
there other issues? Perhaps with code? Filters? (I don't have any
modules other than what is behind the forms themselves.)
Through the use of the news groups and MS Kb, I have learned alot, and
am hoping to avoid the pitfalls as my skills (for what they are)
advance. What is the best way to re-distribute a front end with
respect to TS when changes are made (about every 2 months I get a
couple tools and business rules to add/update)?
TIA for the advice, and many more thanks for all the MVP dedication to
answering novice questions!
EricO