how to fix DEtectIdletime in access

hi guys,

i have a access 2003 database, when i click to open it comes up with the following error attached.
how can i fix this?

 Error for access
ammartahir1978Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
try pressing the SHIFT key while opening the db.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

  in your Autoexe Marco or Startup form (in database options), your trying to open a form DetectIdleTime.

  Check one of your old DB's and if you have that form, import it into the app or remove the form open command for it.

  My guess is that at some point, you created a hidden startup form to detect idel time based on the MSKB article, which suggest this and the use of Screen.ActiveForm and Screen.ActiveControl to determine if a user is active or not.

JimD.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

  I should add this is not something in Access per say, but something that some one added at some point.

JimD.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Rey Obrero (Capricorn1)Commented:
were you able to open the db pressing the SHIFT key?

post back if you did.
0
 
ammartahir1978Author Commented:
yes i open it and i can see all the querys and stuff but no forms??
0
 
ammartahir1978Author Commented:
one more thing i want to add is this all happened after i compact the database
0
 
Rey Obrero (Capricorn1)Commented:
from the menu
tools > options > check Hidden Objects click Apply, Ok

then
tools >startup
look in the Display form/page if there is an entry
   select None

 if there is no entry in the Display form/page,
select Macros from the database objects
look for the macro AutoExec
open in design view and look for the OpenForm in the Action column
see what the name of the form that is being opened,
if the form name is the one missing, delete this Action from the macro


0
 
ammartahir1978Author Commented:
Hi capricon1,

Thank you for you help but I think main issue is all my forms has disappeared after I compacted the database, is that possible at all? Or are they be somewhere on my machine?

Can I retrieve them?

Regards,
0
 
Rey Obrero (Capricorn1)Commented:
do you have any backup copy of the db?
0
 
ammartahir1978Author Commented:
Backup is corrupted unfortunately!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.