Solved

running ADP projects from Terminal Server

Posted on 2004-10-27
762 Views
Last Modified: 2012-06-21
Hi there Access guru's,

I have an ADP project that works OK in development.  We want to deploy it on Terminal Server, and that is where the problems begin.  The first user to access it is OK. The second one will receive a message stating that the ADP file is in "read only" mode.  Then the code starts to kack - nothing works properly.

Any tips?

This is a continuation from:
http://www.experts-exchange.com/Databases/MS_Access/Q_21181146.html
0
Question by:yitz99
    6 Comments
     
    LVL 1

    Author Comment

    by:yitz99
    Maybe some more points will get some answers :)
    0
     
    LVL 1

    Author Comment

    by:yitz99
    Maybe more points will get some answers :)
    0
     
    LVL 36

    Expert Comment

    by:SidFishes

    compile your adp  to an ade and you shouldn't see the error

    check here...
    http://www.experts-exchange.com/Databases/MS_Access/Q_20186110.htm
    0
     
    LVL 1

    Author Comment

    by:yitz99
    Thanks for the tip SidFishes, but it didn't work :(.   Same behaviour experienced - user #1 OK!, user #2 - kack!

    I also cant seem to view the above article.  Could you archive it and send it to: dwaxman@jp-inc.com?

    Some other updates -
    * I converted the project to Access 2002 - 2003
    * I adjusted the macro/security settings to 'low'
    0
     
    LVL 36

    Accepted Solution

    by:
    ok...forget that link..on further investigation..

    adp's and ade's are single user and aren't going to work properly with more than one...this is "by design"

    the solution i've seen is to distribute multiple adp/ade's to user folders on the TS

    so

    user1 gets

    \\ts\user\user1\myApp.adp

    user2 gets

    \\ts\user\user2\myApp.adp

    etc

    then use something like

    http://www.jsiinc.com/SUBB/tip0800/rh0851.htm

    to run a script for each user to point to the proper folder on logon...
    0
     
    LVL 1

    Author Comment

    by:yitz99
    Well, I guess that explains it!

    It is hard to beleive that there isn't an article that specifically addresses this issue - how to deploy ADP projects on TS!?
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Learn The Basics of Ethical Hacking & Pen Testing

    Computer and network security is one of the fastest growing and most essential industries in technology, meaning companies will pay big bucks for ethical hackers. This is the perfect course to leap into this lucrative career, learning how to use ethical hacking to reveal ...

    Suggested Solutions

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

    856 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now