mdw Network issue?

[Br1an_g]

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

 

[Joan Wild]

Please post what's in the target of the shortcut that another user is using.

 

[Br1an_g]

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

 

[Joan Wild]

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?

 

[Br1an_g]

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

 

[Joan Wild]

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.

 

[Br1an_g]

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

 

[Joan Wild]

Another idea - did you create a shortcut and copy it to them? Have them
check the properties of the shortcut. The 'start in' property may be
referencing your PC.

As for using system.mdw on the network when starting Access alone (no
shortcut), that is because you are joined by default to that system.mdw.

I suggest you use the workgroup administrator (Tools, security) and rejoin
system.mdw in the windows system folder on your PC.

If you are using 2000 or prior the workgroup administrator is started via
Start, run, wrkgadm.exe

 

[Br1an_g]

Thanks again for your quick response.

the 'Start In' is pointing to:
"C:\Program Files\MicrosoftAccess\Office\MSACCESS.exe"

I have also tried:
"\\ServerName\GHLC\ComplaintsDatabase"

I have joined my default system.mdw in my WINNT folder so
my standalone access no longer prompts for a password.

I will be on site at the area that is using the database
tommorow so will carry out some testing to see if i can
identify anything else.

Thanks again

Brian

 

[Immanuel Sibero]

Hi,

Strange!...

Maybe you could set up this particular user on your machine as a user and
set a password. In other words, if that user computer wants to access your
machine then let it. Then maybe you can see what it's doing or what file it
wants to access.


Immanuel Sibero