Can't Use Icons To Start Access Application

[Guest]

Trying to start an application via an icon(desktop shortcut) or
double-clicking on the '.mdb' itself won't work but executing Access &
opening the application from Access does work. Here are the symptoms:
1) Every thing works fine unless I FBF (filter by form) some records.
THEN, if I close out the application, the next time I try to initiate it by
the icon, nothing happens.

2) After filtering & closing out the application, the .ldb goes away BUT it
comes back in when I click on the icon only nothing happens.

3) The application still CAN be run but only by starting Access & telling
it which .mdb to open.

4) If I 'log off' windows & then log back on, I can then re-start the
application from the icon.

I really need some help with this one.

 

[Wayne Morgan]

Check task manager after you shut down the application and see if Access is
really shut down. Look for msaccess.exe in the task manager.

Try a repair install of Office. Go to Help|Detect and Repair...

Run a spy ware and virus check. Probably do this one first since it's a good
idea anyway.

 

[Guest]

Thanks for the reply Wayne. Another symptom is: other similar applications
don't have this problem. Only This one. What Access attributes might cause
it?

Thanks
________
KenC

Check task manager after you shut down the application and see if Access is
really shut down. Look for msaccess.exe in the task manager.

Try a repair install of Office. Go to Help|Detect and Repair...

Run a spy ware and virus check. Probably do this one first since it's a good
idea anyway.

 

[Guest]

Wayne,
I looked in the Task Mgr and sure enough, msaccess.exe was still in there.
Currently running latest update to Office XP. Also did Detect and Repair;
did not help. What, if anything is peculiar to 'filter by form'?

Thanks for the help. At least I'm on the right track.
________
KenC

Thanks for the reply Wayne. Another symptom is: other similar applications
don't have this problem. Only This one. What Access attributes might cause
it?

Thanks
________
KenC

 

[Wayne Morgan]

I don't know what would be peculiar to "filter by form" to cause this other
than memory would be used differently for every different thing that is
done. However, this sort of thing is usually a conflict with something else
that is running, which is why I recommended doing the spy ware check.

 

[Tony Toews]

I looked in the Task Mgr and sure enough, msaccess.exe was still in there.

Good catch Wayne.

Ken

Access minimizes to Windows 95/NT toolbar instead of closing
http://www.mvps.org/access/bugs/bugs0005.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Wayne Morgan]

I seem to remember someone commenting that Access sometimes won't shut down
properly if all recordsets opened in code are properly closed and their
object variables set to Nothing prior to trying to shut down Access.