Re: MS Access 2000 and SQL 2000

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

It looks like it's a permissions thing. The Admin account has RWE permission to the
folder where the Access database is, but the user does not. Check the permissions on the
folder where the Access database is and make sure it has Read, Write, Execute
permissions for Everyone, and that the permissions prorogate down to all folders and
files.

Vic


"Sam" <Sam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B154AA6C-0A51-4C8D-9D0D-21917B449EEE@xxxxxxxxxxxxxxxx
I have a user application that runs on MS Access 2000. On one client PC, the
user's PC log in and got the following error:
17[Microsoft][ODBC SQL Server Driver][DBNETLIB]AQL Server does not
exist or access denied.:53[Microsoft][ODBC SQL Server Driver][DBNETLIB]
ConnectionOpen(Connect())..

Its very strange because when I log into the same PC with local admin
rights, or with my ID, I have no problem to login to system. However, when
the user try her login, the above error occurs.

Initial diagnose thought it was MDAC, but I doubt. Any one has any idea
what is the cause?

Thanks in advance.


.

Relevant Pages

  • Re: I really screwed up group policy this time...!
    ... admin account and revise the policy to be less restrictive. ... >>>> accessing Folder Options through Windows Explorer's Tools menu. ... >>>> In the Permissions box, change the Read setting, and only the ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Location for shared Access database
    ... Can anyone tell me where I should put a simple Access database file in order to be accessible for every computer in the network? ... I don't think that the "Programs" folder is the right place. ... For a network-shared database, use SQL Server instead: ... This will work on Vista as well, although you'll need to adjust the local folder permissions since users don't have write permissions on c:\ by default. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Minimum NTFS Permissions - Theres such a thing???
    ... ?2001 Microsoft Corporation. ... HOW TO: Set Minimum NTFS Permissions Required for IIS 5.0 to Work WGID:198 ... " List Folder Contents" ...
    (microsoft.public.inetserver.iis.security)
  • Re: Unable to delete orphaned 1.5 GB System Restore folder
    ... The fact that the tech support is based in India has nothing to do with the ... If so you may want to leave this folder alone. ... down to all children folders because i can set those permissions to ... try deleting from the command line using system by using the AT ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Unable to delete orphaned 1.5 GB System Restore folder
    ... The only computers i fix are my own. ... If so you may want to leave this folder alone. ... it includes all subdirectories with inherited permissions. ... try deleting from the command line using system by using the AT ...
    (microsoft.public.windowsxp.security_admin)