Re: Access denied when .ldb is present (only for XP-SP2)

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

We aren't seeing this, but I'd take a guess that all of our users
with Win XP are either (a) SQL Server, or (b) Administrators
on their own PC's (not that that should make a difference
to file server rights).

On my own PC (XP Pro, SP2), I never see locked files -
even though I download mdb's from the internet and
receive them in mail.

(david)

"Luke Hinson" <LukeHinson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6E055FE7-CC23-477E-8369-577489E92ED1@xxxxxxxxxxxxxxxx
>I don't think its our network, as i can access it when no one else is, and
> non XP users can access it whether anyone else is or not.
>
> 1) I don't know the answer to that question, will have to find it out - i
> know that if a user is an XP user is signed in and another XP user tries,
> it
> doesn't allow access, but i haven't knowingly tested it when i KNEW the
> other
> user wasn't XP. But I have had non-XP users sign in after i (XP) was
> signed
> in.
>
> 2) XP Pro (both host and remote user)
>
> 3) same domain (all users)
>
> 4) not mapped drives - i connect to host pc, sign in and then open
> database
>
> 5) only (.) is in [filename].mdb
>
> "david epsom dot com dot au" wrote:
>
>> Since files are locked when they come from unsecure source,
>> is it possible that something about your network makes other
>> users look like they are insecure?
>>
>> 1) Do xp users have this problem when the only other
>> users are ALSO xp users?
>>
>> 2) using xp pro or home?
>>
>> 3) multiple domains?
>>
>> 4) mapped drives or unc paths?
>>
>> 5) . (dot) in the network path or file name?
>>
>> (david)
>>
>> "Luke Hinson" <Luke Hinson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:D961B080-FB82-481F-BCC0-4407EBAA393D@xxxxxxxxxxxxxxxx
>> > Prior to host pc and some user pc's being upgraded to XP SP2, multi
>> > users
>> > could sign in to Access 2003 DB simultaneously. Since upgrades, if .ldb
>> > is
>> > present (someone else already in), XP SP2 users cannot access. Non-XP
>> > users
>> > can still access. When current user exits, XP users can then get in.
>> >
>> > Any ideas on how to turn this security off ?? I want to get back to
>> > multiple users. Or can anyone point to where this is documented? I
>> > know
>> > hte
>> > .ldb is showing its "locked", but its not for non-XP users.
>>
>>
>>


.

Relevant Pages

  • Re: 4 Queries about DB clustering
    ... All drives will need to be visible to all hosts for failover. ... I support the Professional Association for SQL Server ... > I have a similar situation where I plan to install/configure multi-instance> cluster. ... SQL binaries will live on>> the local disks of each cluster host. ...
    (microsoft.public.sqlserver.clustering)
  • Re: 4 Queries about DB clustering
    ... but live on a single host node at a time. ... instance is an independent installation of SQL server. ... www.sqlpass.org "Kamal Hassan" wrote in message ... or do have any recommendation for the above setup before> setting up clustering. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Re:Connection
    ... I know you host a web site on your ISP. ... You want to know you'd better host the SQL server on ...
    (microsoft.public.windows.server.sbs)
  • Re: Active/Active configuration queries
    ... Geoff N. Hiten ... I support the Professional Association for SQL Server ... It is "shared nothing" in that only a single host actually ... of their storage systems to their connected hosts. ...
    (microsoft.public.sqlserver.clustering)
  • Uploading / Downloading data.
    ... I have an app that uses MS SQL server on the host, ... need to transfer data to a mobile device. ... connection to the server. ...
    (microsoft.public.sqlserver.ce)