Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Security issues

Discussion in 'Information Technology' started by Mr, Jul 28, 2006.

  1. Mr

    Mr
    Expand Collapse
    Guest

    I have a database made from access 2000 on my network it works well on 90% of
    PCs, on 10 % of PCs access asks me for a user name and password. I know this
    is not related to the DB, just wondering if anyone has encountered this
    before.
     
  2. Loading...


  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Do those 10% of the PCs have that same issue with other databases?

    If so, it's possible that a non-standard Workgroup file (.MDW file) has been
    associated with their copy of Access.

    Open the Immediate window (Ctrl-G), type the following into it and hit
    Enter:

    ?syscmd(acSysCmdGetWorkgroupFile )

    You should get a file name back. Is it different on the 10% of the PCs?


    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Mr" <Mr@discussions.microsoft.com> wrote in message
    news:B4DC9B55-9D38-43F8-9D55-E55BBD4CD5AA@microsoft.com...
    > I have a database made from access 2000 on my network it works well on 90%

    of
    > PCs, on 10 % of PCs access asks me for a user name and password. I know

    this
    > is not related to the DB, just wondering if anyone has encountered this
    > before.
     
  4. Mr

    Mr
    Expand Collapse
    Guest

    Thank you so very much Douglas i compared the files and obviously they werent
    the same I replaced them and now everything works like a charm thank you
    thank you thank you !!!

    "Douglas J Steele" wrote:

    > Do those 10% of the PCs have that same issue with other databases?
    >
    > If so, it's possible that a non-standard Workgroup file (.MDW file) has been
    > associated with their copy of Access.
    >
    > Open the Immediate window (Ctrl-G), type the following into it and hit
    > Enter:
    >
    > ?syscmd(acSysCmdGetWorkgroupFile )
    >
    > You should get a file name back. Is it different on the 10% of the PCs?
    >
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Mr" <Mr@discussions.microsoft.com> wrote in message
    > news:B4DC9B55-9D38-43F8-9D55-E55BBD4CD5AA@microsoft.com...
    > > I have a database made from access 2000 on my network it works well on 90%

    > of
    > > PCs, on 10 % of PCs access asks me for a user name and password. I know

    > this
    > > is not related to the DB, just wondering if anyone has encountered this
    > > before.

    >
    >
    >
     
  5. Mr

    Mr
    Expand Collapse
    Guest

    Thank you Doug great tips !!! Found file, renamed it, replaced it works great
    !!!

    "Douglas J Steele" wrote:

    > Do those 10% of the PCs have that same issue with other databases?
    >
    > If so, it's possible that a non-standard Workgroup file (.MDW file) has been
    > associated with their copy of Access.
    >
    > Open the Immediate window (Ctrl-G), type the following into it and hit
    > Enter:
    >
    > ?syscmd(acSysCmdGetWorkgroupFile )
    >
    > You should get a file name back. Is it different on the 10% of the PCs?
    >
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Mr" <Mr@discussions.microsoft.com> wrote in message
    > news:B4DC9B55-9D38-43F8-9D55-E55BBD4CD5AA@microsoft.com...
    > > I have a database made from access 2000 on my network it works well on 90%

    > of
    > > PCs, on 10 % of PCs access asks me for a user name and password. I know

    > this
    > > is not related to the DB, just wondering if anyone has encountered this
    > > before.

    >
    >
    >
     

Share This Page