Workgroup file in Office 2003

  • Thread starter Thread starter Derrick
  • Start date Start date
D

Derrick

Hello everybody!

I have a question for everyone about Access 2003. When we set users to
a workgroup file that my supervisor created, it will stay for a couple
of days or so. When that user that is logged into the database
securely via a username/password, he/she loses that workgroup file.
99% of the time it will revert to a new system file. We are running
primarily running Windows XP Pro with the exception of three comptuers
that are in workrooms and they are running Windows 2000. Any help
would be greatly appreciated. Thanks
 
Derrick said:
Hello everybody!

I have a question for everyone about Access 2003. When we set users to
a workgroup file that my supervisor created, it will stay for a couple
of days or so. When that user that is logged into the database
securely via a username/password, he/she loses that workgroup file.
99% of the time it will revert to a new system file. We are running
primarily running Windows XP Pro with the exception of three comptuers
that are in workrooms and they are running Windows 2000. Any help
would be greatly appreciated. Thanks
Click to expand...

The classic tried and tested configuration is to have the custom WIF (mdw)
in a public folder on a server, usually with the app's back end file. It
sounds like you have modified the default "system.mdw" file and this is
somehow being periodically overwritten with a new, unmodified one.

BTW, stay joined to the custom "system.mdw" WIF by default and join the
custom one on a session by session basis using a shortcut with a commend
line in the format

"full path to MSACCESS.exe" "full path to your app.mdb" /wrkgrp "full path
to your WIF.mdw"

including the quotation marks.

HTH - Keith.
www.keithwilby.com.
 
Hey Keith,

I am using that command, but occassionally I am getting an error
message. Every three or four tries, and on the fifth try, it will
work. BTW, we have about 15 databases, that is using that same
WIF(mdw) file. Any help will be greatly appreciated.
 
Derrick said:
Hey Keith,

I am using that command, but occassionally I am getting an error
message. Every three or four tries, and on the fifth try, it will
work. BTW, we have about 15 databases, that is using that same
WIF(mdw) file. Any help will be greatly appreciated.
Click to expand...

This is a different problem to the one you originally posted - can you
clarify what the problem is and post any error messages?

Regards,
Keith.
 
Sorry about that, maybe I should have said that we had tried that
command. We had already tried that but it give us the error about 4
times and on the fith time it would accept it. It said on the
shortcut, "Microsoft Office Access couldn't find file
"\\server\folder\folder\folder\Wrkgroup.mdw". This file is required
for startup.
 
Hi Derrick,

I would check if maybe this is a network issue. Make sure all users have
full privileges on the folder.
Can you reproduce the error if you were to map a drive letter to the folder
and use the drive letter instead of the UNC name?


Immanuel Sibero
 
Back
Top