Re: mdw Network issue?

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

From: Br1an_g (br1an_graham_at_NOSPAMyahoo.co.uk)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 07:09:44 -0800

In response to your questions:

this is before Access opens they get the prompt

there are no links to any file/table on my PC

I know that it is using this file as the.ldb file
associated with it is created whenever i open Access.

I agree, I will be changing the name of the workgroup file
to a more suitable one, once i have this issue resolved.

thanks again for your input

Brian

>-----Original Message-----
>Does Access actually open, and then they get this prompt,
or is it before
>Access opens?
>
>I'm thinking that there is a table link that's to your
PC, or there is a
>link in the mdb to a file on your PC (an image or
something?).
>
>I don't think the shortcut is causing this.
>
>When you open access (no shortcut), you say it is now
using the system.mdw
>on the network - how do you know this?
>
>Not related, but I would have chosen a name other than
system.mdw for the
>secure workgroup file, as it is confusing.
>
>--
>Joan Wild
>Microsoft Access MVP
>
>"Br1an_g" <br1an_graham@NOSPAMyahoo.co.uk> wrote in
message
>news:fb8301c40cf0$99c78290$a101280a@phx.gbl...
>> All of the network drives are set on log on using an NT
>> script so im sure they are mapped correctly.
>>
>> the user sent me a screen dump of the prompt and it is
>> deffinately a prompt for a network password for my own
Pc
>> name. message is:
>> "Incorrect password or unknown username for
\\MyPcName\C$"
>> Connect As, and Password areas to log into.
>>
>> They are on the network as i can remote access the User
Pc.
>>
>> When i open acces (no command line parameters)it is now
>> using the system.mdw on the network as my default file,
>> could this be an issue?
>>
>> Im a bit stumped as to why it is asking for access to my
>> own PC.
>>
>> thanks for your input
>>
>> Brian
>>
>> >-----Original Message-----
>> >I would definitely use the one with the UNC pathnames.
>> Then you don't have
>> >to rely on users' computers being mapped correctly.
>> >
>> >Are they really getting a network login prompt?
Usually,
>> if the user isn't
>> >currently connected to the network, they would get an
>> error message, not a
>> >network login prompt.
>> >
>> >Also why do you think they are getting a prompt to
login
>> to your PC rather
>> >than the network?
>> >
>> >--
>> >Joan Wild
>> >Microsoft Access MVP
>> >
>> >"Br1an_g" <br1an_graham@NOSPAMyahoo.co.uk> wrote in
>> message
>> >news:f9b201c40cce$dc897a10$a101280a@phx.gbl...
>> >> thanks for your reply
>> >>
>> >> command line is:
>> >>
>> >> "C:\Program Files\Microsoft
>> >>
>>
Office\Office\MSACCESS.EXE" /User"" "Z:\GHLC\ComplaintsData
>> >>
>>
base\GHLC.mdb" /wrkgrp "Z:\GHLC\ComplaintsDatabase\system.m
>> >> dw"
>> >>
>> >> Ive tried it with the actual server name as well:
>> >>
>> >> "C:\Program Files\Microsoft
>> >>
>>
Office\Office\MSACCESS.EXE" /User"" "\\ServerName\GHLC\Comp
>> >>
>>
laintsDatabase\GHLC.mdb" /wrkgrp "\\ServerName\GHLC\Complai
>> >> ntsDatabase\system.mdw"
>> >>
>> >> Brian
>> >> >-----Original Message-----
>> >> >Please post what's in the target of the shortcut
that
>> >> another user is using.
>> >> >
>> >> >--
>> >> >Joan Wild
>> >> >Microsoft Access MVP
>> >> >
>> >> >"Br1an_g" <br1an_graham@NOSPAMYahoo.co.uk> wrote in
>> >> message
>> >> >news:eca501c40c36$02d72d00$a301280a@phx.gbl...
>> >> >> Hi,
>> >> >>
>> >> >> Both the database, and the MDW file reside in a
>> shared
>> >> >> folder on a network drive (that all users have
acess
>> to)
>> >> >> I created the .mdw file by using wrkgrpadmin.exe
and
>> >> >> placed it in this shared folder with the
actual .mdb
>> >> file.
>> >> >> When i open the database using the command line
>> >> parameters
>> >> >> for this .mdw file i can see that both the
database
>> >> >> and .mdw file are in use from the .ldb files in
the
>> >> folder.
>> >> >> Still whenever any1 else opens the database, it
>> prompts
>> >> >> for the network password for my own PC.
>> >> >>
>> >> >> how do i stop it prompting for the network
apssword
>> for
>> >> my
>> >> >> PC? i thought that by using command line
parameters
>> it
>> >> >> would only look for the mdw specified..it
currently
>> >> looks
>> >> >> like it is looking for the mdw on my pc.
>> >> >>
>> >> >> I hope this can be resolved as the database goes
live
>> >> in 2
>> >> >> weeks.
>> >> >>
>> >> >> Many Thanks
>> >> >>
>> >> >> Brian
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>
>.
>

Relevant Pages

  • Re: mdw Network issue?
    ... Does Access actually open, and then they get this prompt, or is it before ... Access opens? ... > All of the network drives are set on log on using an NT ... > When i open acces (no command line parameters)it is now ...
    (microsoft.public.access.security)
  • Re: Command prompt is displayed briefly, then disappears
    ... If you search for accessories and then open the folder and click command ... prompt, will it run? ... opens. ... MS MVP-IE, Mail, Security, Windows Client - since 2002 ...
    (microsoft.public.windowsxp.general)
  • Re: second form to edit existing info
    ... Thanks for the prompt reply. ... name in the combo box and it is not in my list, the contact list form opens ... I have the following code for combo box on entry form: ... Dim stDocName As String ...
    (microsoft.public.access.forms)
  • Re: Workgroup
    ... system.mdw when a database is open for the first time. ... The workgroup is about the session, ... prompted by having everyone use a workgroup that forces a prompt. ... Step 2 is to then create a shortcut that opens Access while specifying your ...
    (microsoft.public.access.security)
  • Re: workbook_open
    ... "Tom Ogilvy" wrote: ... > links and not prompt. ... You would need to open a 2nd workbook which uses code ... >> the user opens this file, he is prompted about updating links. ...
    (microsoft.public.excel.programming)