Re: sbs2003 and rights/policies

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Frank Jacobs wrote:

Hello;

I have a problem at a client.
They use a client/server CRM packet. DB runs on server. Type of server has
no importance, but it is access based.

Anyways, the server is a Windows SBS 2003 with SP1. Clients run XP Pro SP2.
Firewall is disabled by client group policy. Users have admin rights on
proper pc's. The application writes db entries via odbc on a share that
needs to be mapped on every pc. Users have write/change access on NTFS level
on folders on server and full control on share.

Compare the access privileges (NTFS) for administrators vs users on that folder. Turn up auditing on it too.

Now the strange part:
When we log on as administrator on the pc's, the app works FINE. No
problems, never. When we logon as user, application crashed due to rights
somewhere.
Another strange thing: when I delete the user profile on the pc and make a
new profile, the application works for some moments. Depending on how long.
After a while it just stops working and application crashes again. Then
when u logon as domain admin, program works again. New user profile and app
works again...

Most likely cause is insufficient privileges to the files in the share - Access uses temporary files for locking purposes that are created on demand (by the first user to login to the application), and deleted automatically when appropriate (after last person quits).

If a user is first to start the application, and they don't have the requisite privileges, the locking files cannot be created. But if an administrator is first, the locking files can be created, and then a user who starts the application can use the existing locking files.

--
Steve Foster [SBS MVP]
---------------------------------------
MVPs do not work for Microsoft. Please reply only to the newsgroups.
.



Relevant Pages

  • Re: Unable to save client desktop
    ... You gave it the same name as the old server. ... The best workaround at this point is to run the Files and Settings Transfer ... I rejoined the client to the domain after the rebuild but that overwrote ... the user profile for the user having issues and let it recreate itself. ...
    (microsoft.public.windows.server.sbs)
  • Re: sql client connectivity errors
    ... I have disabled the anti-virus real-time scanning on both the server and the ... clients to prevent it from locking files, ... said it is so random and there is no particular client more prone to it than ... but have posed them to the software vendor and am ...
    (microsoft.public.sqlserver.clients)
  • Re: How to reset winxp client profiles
    ... When I look at the user profiles, there are three 'account unknown' listed, ... with the old local user profile. ... When you reinstall SBS server, ... You do this in http://servername/connectcomputer in client ...
    (microsoft.public.windows.server.sbs)
  • Re: migration question
    ... we already own SBS 2k. ... We plan to move the company intranet from the SBS server ... >> configured to access the new server, but keep thier current user profile? ... >> Mon, user comes into work, logs into the network, client automatically ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Unable to save client desktop
    ... You gave it the same name as the old server. ... The best workaround at this point is to run the Files and Settings Transfer Wizard. ... I rejoined the client to the domain after the rebuild but that overwrote the ... the user profile for the user having issues and let it recreate itself. ...
    (microsoft.public.windows.server.sbs)