Access froze up while running VBA code

[jcfraun]

I'm teaching myself to code in VBA and clearly I made an error, because Access is frozen up (trying to run a function) and I get the following error message when I try to end the program through the task manager:

You can't exit Microsoft Access now.
If you're running a visual basic module that is using OLE or DDE, you may need to interrupt the module.

I say ok and then I'm able to end the program through the task manager.

However, when I open Access again, it still has that file open and I can do nothing.

Any suggestions?

 

[PHV]

Any suggestions?
Well, without seeing the code it's hard to suggest anything ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[smedvid]

Do you have multiple versions of MS Access on PC? If so, did they get installed in the proper order?

Is it a coding issue or MS Access issue?

Attempt to reproduce problem on another PC perhaps...

Did you compact/repair lately?

As PHV states, without a look at the code; it is tough to offer an opinion to the RCA of the issue.

htwh,

Steve Medvid
IT Consultant & Web Master

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[jcfraun]

This has been resolved. Thanks!