Prev: How to Handle Feb 28 and 29?
Next: Slow logon on a Multihomed server
From: Matt W Matt on 2 Jul 2008 13:44
Good afternoon. I've got a user running Access 2002 SP3 on a Windows XP
machine who receives an error that Microsoft Access couldn't find file
C:\Documents and Settings\<profile>\Application
Data\Microsoft\Access\system.mdw when trying to open a database stored in
C:\Documents and Settings\All Users\Desktop.

Other users can open the mdb without issue.
This user can open a copy of this database on another machine in the same
conditions with no issues.
The system.mdw file exists in the folder that Access says that it can't find
the file in, and renames itself in increments (system1.mdw, system2.mdw, etc.)

I have done the following:
Repaired and reinstalled Office.
Renamed the local profile for the user.
Re-registered DAO with regsvr32 msjtes40.dll.
Copied a system.mdw file from another location and placed it in C:\Program
Files\Common Files\System, then created a shortcut to the db pointing to this
..mdw file, same error.
Granted the user local admin rights. This produced a new error, which
states that the VB Project is corrupt when she tries to open reports in the
db.

Again, others can open the db just fine on the machine, just not this user,
who can open a different copy of the db just fine on other machines. One odd
thing about this user that I've noticed is that every time that she opens
Access it opens the new user identification dialogue, prompting for a name
and ID to identify her with.

Any suggestions?

From: Chris O'C via AccessMonster.com on 3 Jul 2008 02:11
Looks like something is wrong with her installation. Log in as Windows
administrator, uninstall Office 2003, then use this utility to complete the
uninstall:

http://support.microsoft.com/default.aspx?id=290301

Make sure her profile doesn't keep the ..\application data\microsoft\access
folder. Delete it and its files if you have to. (Those files should only be
the system.mdw and ACWZUSRT.MDT files. Any others, move elsewhere before
deleting the folder.) Now install Office 2003 again while still logged in as
Windows admin.

Have her log into her Windows account and copy the front end from the server
(you do have the db split, right?) and try to open it on her PC. Please let
us know if that works or still gives errors.

Chris
Microsoft MVP


Matt W wrote:
>Good afternoon. I've got a user running Access 2002 SP3 on a Windows XP
>machine who receives an error that Microsoft Access couldn't find file
>C:\Documents and Settings\<profile>\Application
>Data\Microsoft\Access\system.mdw when trying to open a database stored in
>C:\Documents and Settings\All Users\Desktop.
>
>Other users can open the mdb without issue.
>This user can open a copy of this database on another machine in the same
>conditions with no issues.
>The system.mdw file exists in the folder that Access says that it can't find
>the file in, and renames itself in increments (system1.mdw, system2.mdw, etc.)
>
>I have done the following:
>Repaired and reinstalled Office.
>Renamed the local profile for the user.
>Re-registered DAO with regsvr32 msjtes40.dll.
>Copied a system.mdw file from another location and placed it in C:\Program
>Files\Common Files\System, then created a shortcut to the db pointing to this
>.mdw file, same error.
>Granted the user local admin rights. This produced a new error, which
>states that the VB Project is corrupt when she tries to open reports in the
>db.
>
>Again, others can open the db just fine on the machine, just not this user,
>who can open a different copy of the db just fine on other machines. One odd
>thing about this user that I've noticed is that every time that she opens
>Access it opens the new user identification dialogue, prompting for a name
>and ID to identify her with.
>
>Any suggestions?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/200807/1

 | 
Pages: 1
Prev: How to Handle Feb 28 and 29?
Next: Slow logon on a Multihomed server