Access crashes for particular user

O

okschlaps

I have a problem with Access crashing for one particular user. It's one
particular database - she can use others. But the database is widely used by
several others. Her security profile is not unique. My IT guys insist it's
the database, but I don't understand why she would be the only person with
the problem. I've tried creating a new user name for her, but it didn't help.
I'm stumped. Does anyone have any ideas? Thanks
 
J

John Nurick

Is the problem with the user or the workstation? Does the database work
normally for this user at other workstations? Do other users have
problems when using this database on this user's workstation?

If the database is split, have you replaced this user's copy of the
front end?
 
J

John W. Vinson

I have a problem with Access crashing for one particular user. It's one
particular database - she can use others. But the database is widely used by
several others. Her security profile is not unique. My IT guys insist it's
the database, but I don't understand why she would be the only person with
the problem. I've tried creating a new user name for her, but it didn't help.
I'm stumped. Does anyone have any ideas? Thanks

What are the symptoms of the crash?

Assuming it's a MDB file, try opening the database on her computer, open the
VBA editor (Ctrl-G for instance), and check Tools... References. Anything
missing? Select Debug... compile <database> and correct any errors. Also if
this is a frontend to a shared backend database, check Tools... Database
Utilities... Linked Table Manager in the database menu, select all tables and
make sure the link to the backend is correct.

If it's a .MDE file, recreate it and give her a new one.

It may even be necessary to COMPLETELY uninstall Access and reinstall, but
since other databases work that seems unlikely!

John W. Vinson [MVP]
 
Top