G
Guest
Hi!
I have this issue in Access 2000 - much less of it in Access 2003 (when I
say yes to block unsafe code...).
I have been struggling with this issue for a long period of time, and I hope
someone has an answer to this. Here's what's happening:
I have a database with forms (it's an Access solution with forms, that is),
and when a user is pushing a button - for instance for opening a form - or to
filter it - he/she is sometimes (very often) thrown out of entire Access.
Access just closes down, and you have to start the application again...
It would be nice if there was an error in my code causing this. However,
this problem is in more solutions, and it's not consistent at all. Sometimes,
Access closes down suddenly when a user move from one form to another
(typically a menu-form where they for instance select to go to the
customer-form - and typically the menu form is not closed (the other one will
be opened "on top of it")). Another situation is when I have forms where I've
created buttons for sorting... Let's say you can push one button to sort by
name, another to sort by number. When you push one of these buttons, my code
sets the form's record source to the corresponding query. This is the best
way to reproduce the problem - but Access won't crash all the times - but
more than normal.
However, in a general solution, this problem is there, and I wonder if it's
something with Access 2000 - but then again, it's not totally okey in Access
2003, neither.
There's no traces in the event log about the shutdown of Access, neither.
What shall I do?
I have this issue in Access 2000 - much less of it in Access 2003 (when I
say yes to block unsafe code...).
I have been struggling with this issue for a long period of time, and I hope
someone has an answer to this. Here's what's happening:
I have a database with forms (it's an Access solution with forms, that is),
and when a user is pushing a button - for instance for opening a form - or to
filter it - he/she is sometimes (very often) thrown out of entire Access.
Access just closes down, and you have to start the application again...
It would be nice if there was an error in my code causing this. However,
this problem is in more solutions, and it's not consistent at all. Sometimes,
Access closes down suddenly when a user move from one form to another
(typically a menu-form where they for instance select to go to the
customer-form - and typically the menu form is not closed (the other one will
be opened "on top of it")). Another situation is when I have forms where I've
created buttons for sorting... Let's say you can push one button to sort by
name, another to sort by number. When you push one of these buttons, my code
sets the form's record source to the corresponding query. This is the best
way to reproduce the problem - but Access won't crash all the times - but
more than normal.
However, in a general solution, this problem is there, and I wonder if it's
something with Access 2000 - but then again, it's not totally okey in Access
2003, neither.
There's no traces in the event log about the shutdown of Access, neither.
What shall I do?