Microsoft Access can't change the working directory error message

[frankrizzo]

I have an Access 2003 database on one of my w2k3 servers and when regular
users launch the app, they get the following error message:

Microsoft Access can't change the working directory to 'c:\documents and
settings\jane doe\my documents\.'

Once they hit ok, they are able to access the database with no issues. It
seems to be a permission issue somewhere as admins do not get the error
message, only regular users. I tried running regmon during the launching
process to pinpoint where the issue is and ironically, the servers that do
not have the issue end up showing more "access denied" than the server that
is having issues. Any help is greatly appreciated!!!

 

[Tom van Stiphout]

On Wed, 30 Jan 2008 02:36:00 -0800, frankrizzo

The application should not be deployed on a server. Rather it should
be split in front-end and back-end, with the FE on each workstation
and the BE on the server. This is per best practices and should be
implemented right away. There are tools such as Tony Toews' updater
program (http://www.granite.ab.ca/access/autofe.htm) to keep the FE at
the latest version for everyone.

You should not run regmon or any other external tool to pinpoint the
issue, rather you should use the VBA debugger.

-Tom.