AD problem with Microsoft Access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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: Simple setup of domain servers for school labs
    ... So the students logging into the servers will be logging in from both ... Are the student computers stationary in each lab or do they use 'traveling' ... Are the servers all SBS 2003 Standard or a combination of SBS Standard and ...
    (microsoft.public.windows.server.sbs)
  • 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: Discussion: Login portal through linux to get internet and print
    ... restricted to only running Home editions we can no longer force the ... students to log on to a domain. ... out the windows servers and replace them with linux servers. ... Wireless LAN Access Point Controller ...
    (comp.os.linux.misc)
  • Re: Discussion: Login portal through linux to get internet and print
    ... In a school environment we originally had windows domain controllers which our students logged on to, but now with piles of netbooks restricted to only running Home editions we can no longer force the students to log on to a domain. ... Hence this is an opportunity to throw out the windows servers and replace them with linux servers. ...
    (comp.os.linux.misc)
  • 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)