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?
i have a access 2003 database, when i click to open it comes up with the following error attached.
how can i fix this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
were you able to open the db pressing the SHIFT key?
post back if you did.
post back if you did.
ASKER
yes i open it and i can see all the querys and stuff but no forms??
ASKER
one more thing i want to add is this all happened after i compact the database
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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,
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,
do you have any backup copy of the db?
ASKER
Backup is corrupted unfortunately!
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.