AD problem with Microsoft Access

From: Running Man (RunningMan_at_discussions.microsoft.com)
Date: 09/28/04


Date: Tue, 28 Sep 2004 14:11:01 -0700

This is a bizzare problem which only manifests itself in Microsoft Access.
We are an education establishment.
1700 users, 480 clients, 10 servers, AD on 3, 2 DNS, 1 DHCP, 1 Proxy, 1
fileserver, 1 IIS, 1 SQL. All clients on XP SP1 + up to date patches SUS.
Sophos AV on all machines servers all 2003. Using GP for user logins etc

All students have a unique username when logging in eg B92343. The home
folder is mapped to a share on a member server (fs01) which has no other
function than hosting the students data ie in the profile w: is mapped to
\\fs01\students\B92343. When word, powepoint, excel or any other application
is run there is no problem. Permissions are set correctly on all folders and
files can be saved resave etc. When Microsoft Access is loaded and a new
database created the application hangs or chashes with numerous errors.
Unfortunately this only occurs intermittantly.

We have tried deleting local profiles first before logging on - no joy
We have tried elevating the permissions of the group - still no joy

One of the few things that we have tried that is consistent is:
(This is where we are looking for a possible answer)
We changed the location of the home folder from w: on \\fs01\students\B92343
to w: on \\dc01\students\B92343 (one of the domain controllers), set the
permissions appropriately and the problem went away!!

(fs01 and dc01 are connected to a Gb switch and both have Gb network cards.
Gb switch is connected to a 24 port layer 3 fibre switch and distributed to
clients from here)

Why should hosting the home folder on fs01 rather than dc01 make a difference.

Before you say just move all students home folders to dc01 - no can do the
dc only has about 40Gb of HD space. The students share totals about 70Gb.

Note - the students share was originally on dc01 up until 4 months ago but
was moved with seemingly no problems. This problem has only manifested itself
in the last 2 weeks.

DNS servers working OK, WINS server OK, DHCP OK, AD OK - minimal errors in
event logs - none relating to this problem.

If anyone has any ideas it would be greatly appreciated



Relevant Pages

  • Re: 2 domains 1 trust same subnet DNS?
    ... The DNS Servers for STAFF ... should forward to STUDENTS, and vice-versa. ...
    (microsoft.public.windows.server.general)
  • RE: DHCP and Domain suffix search order
    ... Our DHCP server and DNS servers are located in the 'fizi.ca' ... appropriate domain and can resolve any of our other servers. ... I just altered our wireless DHCP Scopes and setup a new sub domain ... The problem we're having is we put servers related to students under ...
    (microsoft.public.windows.server.dns)
  • RE: Use different home folder when connecting to different WTS farm
    ... Setup separate OUs for each farm of servers, then use loopback policy ... they logon to. ... We noticed some applications talk to users home folder ...
    (microsoft.public.win2000.termserv.apps)
  • Re: FE/BE question
    ... At the one client the IT department wasn't willing to setup a special ... folder for the FE on the servers so we had to use the server. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • I need to restrict contact information from the GAL in Outlook and OWA (Exchange 2003)
    ... Exchange 2003 on three servers, Two back end and one front end. ... staff on one server and students on the other. ...
    (microsoft.public.exchange.admin)