[THIN] Re: Content Redirection

  • From: "Rick Mack" <Rick.Mack@xxxxxxxxxxxxxx>
  • To: <thin@xxxxxxxxxxxxx>
  • Date: Wed, 2 Nov 2005 07:10:34 +1000

Hi Chad,
 
The location of system.mdw is defined globally on the server. From
memory (don't have system with access 97 available) you're looking at
HKLM\Sofware\MIcrosoft\Office\8.0\\Access\Jet\3.5\Engines, systemdb.
 
Just change the systemdb value to h:\windows\system.mdw (provided h:\ is
users home drive) and add a line in usrlogon.cmd:
 
if not exist h:\windows\system.mdw copy %systemroot%\system32\system.mdw
<file://\\system.mdw>  h:\windows
 
regards,
 
Rick

Ulrich Mack
Volante Systems


        -----Original Message-----
        From: thin-bounce@xxxxxxxxxxxxx
[mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Schneider, Chad M
        Sent: Wednesday, 2 November 2005 2:56 AM
        To: thin@xxxxxxxxxxxxx
        Subject: [THIN] Re: Content Redirection
        
        

        Now....1 user has access open, another tries to open access
(97), issue with the C:\xxxxx\system.mdw.

         

        I forget, what do I do with that so multi-users can use Access
on the server?

         

        
________________________________


        From: thin-bounce@xxxxxxxxxxxxx
[mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Evan Mann
        Sent: Tuesday, November 01, 2005 8:12 AM
        To: thin@xxxxxxxxxxxxx
        Subject: [THIN] Re: Content Redirection

         

        Good thing I opted to not install it.  I have 3 users who need
it, and I would have limited them to 1 server.

         

         

         

        
________________________________


        From: thin-bounce@xxxxxxxxxxxxx
[mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Schneider, Chad M
        Sent: Tuesday, November 01, 2005 9:11 AM
        To: thin@xxxxxxxxxxxxx
        Subject: [THIN] Re: Content Redirection

        Issue we have found, running 5 instances of Access 97 can bury a
server.

         

        
________________________________


        From: thin-bounce@xxxxxxxxxxxxx
[mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Evan Mann
        Sent: Tuesday, November 01, 2005 7:51 AM
        To: thin@xxxxxxxxxxxxx
        Subject: [THIN] Re: Content Redirection

         

        Efficient from the aspect of the guys who run the servers, but
from the guys who are making DB's and using Access heavily, 97 is much
quicker.

         

        As for running 2 versions, it's easy to do when your talking
Access97. You need to install it after 2003 and then change the MDB
associates back to 2003 as you please.
        
        I have decided not to install 97 on my servers for the 3 users
that need it, but I have the option of letting them still run it on
their desktops becaue they are fat clients.

         

         

         

         

        
________________________________


        From: thin-bounce@xxxxxxxxxxxxx
[mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Schneider, Chad M
        Sent: Tuesday, November 01, 2005 8:31 AM
        To: thin@xxxxxxxxxxxxx
        Subject: [THIN] Re: Content Redirection

        Thanks.

         

        If I had a choice, it would be ONLY be Access 2003, as it is
MUCH more efficient than 97.

         

        
________________________________


        From: thin-bounce@xxxxxxxxxxxxx
[mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Andrew Wood
        Sent: Tuesday, November 01, 2005 7:22 AM
        To: thin@xxxxxxxxxxxxx
        Subject: [THIN] Re: Content Redirection

         

        Don't think so - Server to Client is only for URLs 

         

        I suppose you could publish the content. This isn't pretty mind
- easier to live with the Access on the server. 

         

        If you're concerned about running different versions of Access
on a single box do some searches through Rick's posts  - -he's described
some neat methods of getting multiple versions of access running on the
same server for users.

         

        
________________________________


        From: thin-bounce@xxxxxxxxxxxxx
[mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Schneider, Chad M
        Sent: 01 November 2005 13:12
        To: thin@xxxxxxxxxxxxx
        Subject: [THIN] Content Redirection

        I have an application that pulls MDB's.  Rather than have Access
(97 is required) on the server, I would like to use content redirection
so that if an MDB is encountered, it attempts to open with the local
install of Access on the client machine.  Is this possible?


#####################################################################################
This e-mail, including all attachments, may be confidential or privileged.  
Confidentiality or privilege is not waived or lost because this e-mail has been 
sent to you in error.  If you are not the intended recipient any use, 
disclosure or copying of this e-mail is prohibited.  If you have received it in 
error please notify the sender immediately by reply e-mail and destroy all 
copies of this e-mail and any attachments.  All liability for direct and 
indirect loss arising from this e-mail and any attachments is hereby disclaimed 
to the extent permitted by law.
#####################################################################################

Other related posts: