I have a user who is having a problem with an access database that I
didn't build and haven't had anything to do with in the past.
The database opens up to the switchboard, and she clicks through to
the "look up by facility name" form, and opens it up. So far so good.
She is able to click on and view every single thing on this pretty
complicated form, including opening a variety of secondary forms.
However, whenever she clicks on the drop down menu to select a
facility to view in the form, Access crashes with nothing but the
"send this error to Microsoft?" error message. There is nothing to
give me a clue about what the real problem is.
She's not the only one who uses this database, but she is the only one
who has this problem. Everyone else can use the form just fine. She is
also the only person in her area with windows XP (all the rest have
Win2k). However, I am able to open the database on my computer and I
have no problem using the form to find a facility. I am also running
XP.
I've tried a compact and repair on the Db, but to no avail.
One thing that I think is a little odd is that the person who has
administrative rights to the Db has to log in when she runs it. It
presents here with a login dialog. But neither the woman having this
problem nor myself are presented with a login dialog when we open up
the Db. I don't *think* this would have anything to do with the actual
problem, but I'm not sure. So I just present this datapoint for
completeness.
I'm currently waiting to get administrative access to the form so I
can try making a copy of it and seeing if the copy works or not. Then
also trying to rebuild that single form element and see if that fixes
the problem for the woman.
However, if anyone has any other suggestions for where to poke to find
out what's cause this, I'd be very grateful to hear it.
--
Siobhan Perricone
Systems Developer
Vermont Agency of Natural Resources
(my comments are my own, not my employer's)
didn't build and haven't had anything to do with in the past.
The database opens up to the switchboard, and she clicks through to
the "look up by facility name" form, and opens it up. So far so good.
She is able to click on and view every single thing on this pretty
complicated form, including opening a variety of secondary forms.
However, whenever she clicks on the drop down menu to select a
facility to view in the form, Access crashes with nothing but the
"send this error to Microsoft?" error message. There is nothing to
give me a clue about what the real problem is.
She's not the only one who uses this database, but she is the only one
who has this problem. Everyone else can use the form just fine. She is
also the only person in her area with windows XP (all the rest have
Win2k). However, I am able to open the database on my computer and I
have no problem using the form to find a facility. I am also running
XP.
I've tried a compact and repair on the Db, but to no avail.
One thing that I think is a little odd is that the person who has
administrative rights to the Db has to log in when she runs it. It
presents here with a login dialog. But neither the woman having this
problem nor myself are presented with a login dialog when we open up
the Db. I don't *think* this would have anything to do with the actual
problem, but I'm not sure. So I just present this datapoint for
completeness.
I'm currently waiting to get administrative access to the form so I
can try making a copy of it and seeing if the copy works or not. Then
also trying to rebuild that single form element and see if that fixes
the problem for the woman.
However, if anyone has any other suggestions for where to poke to find
out what's cause this, I'd be very grateful to hear it.
--
Siobhan Perricone
Systems Developer
Vermont Agency of Natural Resources
(my comments are my own, not my employer's)
Comment