On Wed, 21 Mar 2007 12:37:18 -0700, okschlaps
<(E-Mail Removed)> wrote:
>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]
|