Can not open and Error Message

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

Previously I can open my database in access 2002 and 2003 but since my
laptop crash and I reinstalled my Windows Xp, when I run my database in
Access 2002, the erroe message is:
The espressseion on timer you enterred on the event prperty setting produced
the following error: object or class deos not the set of event.
* the expression may not result in the name of a macro, the name of a user
defined function. or [event Procedure]
* There may have been an error evaluating the function, event, or macro

No problem if I run it in Access 2007.

Pleasse help what causes the problem
 
Hello,

Previously I can open my database in access 2002 and 2003 but since my
laptop crash and I reinstalled my Windows Xp, when I run my database in
Access 2002, the erroe message is:
The espressseion on timer you enterred on the event prperty setting produced
the following error: object or class deos not the set of event.
  * the expression may not result in the name of a macro, the name of auser
defined function. or [event Procedure]
  * There may have been an error evaluating the function, event, or macro

No problem if I run it in Access 2007.

Pleasse help what causes the problem
Click to expand...

check your references.
I would bet you're missing a reference to DAO 3.6
Open any code module. go to Tools, References, and look for any
marked MISSING. Deselect them, close the window, reopen it, and
reselect them. Then recompile your code and try again.
 
Allen,

I have checked the reference, it is neither the problem of reference nor the
limited user of Winxp. I run it on my own laptop, not the company's computer.

In my laptop, I have 2 version of Office which are ver 2002 and 2007. there
is no problem if I run it with ver 2007. There is problem for ver 2002. Since
I want to distribute my denomination chruch secretary database whose versions
are mostly 2002, that is why I want it run in ver 2002.

Do you think I need to uninstalled my ver 2002 and reinstall it again?.

Thanks if you still can help me.

--
H. Frank Situmorang


Allen Browne said:
Check your references are okay:
http://allenbrowne.com/ser-38.html

If that is not the issue, perhaps it is permissions. For example, if you are
now logging into WinXP as a limited user rather than a local computer
administrator, it could be this issue that turns up in Vista too:
http://allenbrowne.com/bug-17.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Frank Situmorang said:
Hello,

Previously I can open my database in access 2002 and 2003 but since my
laptop crash and I reinstalled my Windows Xp, when I run my database in
Access 2002, the erroe message is:
The espressseion on timer you enterred on the event prperty setting
produced
the following error: object or class deos not the set of event.
* the expression may not result in the name of a macro, the name of a
user
defined function. or [event Procedure]
* There may have been an error evaluating the function, event, or macro

No problem if I run it in Access 2007.

Pleasse help what causes the problem
Click to expand...
Click to expand...
 
Assuming this is an MDB (not an MDE), it should work okay.

If no other databases work under A2002 either, then a reinstall would be
worthwhile. But if other databases (such as Northwind) do work, then a
decompile might solve it.

Try the steps suggested here:
Recovery Sequence
at:
http://allenbrowne.com/recover.html

Use Access 2002 to do the compacting and decompiling.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Frank Situmorang said:
Allen,

I have checked the reference, it is neither the problem of reference nor
the
limited user of Winxp. I run it on my own laptop, not the company's
computer.

In my laptop, I have 2 version of Office which are ver 2002 and 2007.
there
is no problem if I run it with ver 2007. There is problem for ver 2002.
Since
I want to distribute my denomination chruch secretary database whose
versions are mostly 2002, that is why I want it run in ver 2002.

Do you think I need to uninstalled my ver 2002 and reinstall it again?.

Thanks if you still can help me.

--
H. Frank Situmorang


Allen Browne said:
Check your references are okay:
http://allenbrowne.com/ser-38.html

If that is not the issue, perhaps it is permissions. For example, if you
are
now logging into WinXP as a limited user rather than a local computer
administrator, it could be this issue that turns up in Vista too:
http://allenbrowne.com/bug-17.html

Frank Situmorang said:
Hello,

Previously I can open my database in access 2002 and 2003 but
since my laptop crash and I reinstalled my Windows Xp, when I
run my database in Access 2002, the erroe message is:
The espressseion on timer you enterred on the event prperty
setting produced the following error: object or class deos not the
set of event. * the expression may not result in the name of a macro,
the name of a user defined function. or [event Procedure]
* There may have been an error evaluating the function, event, or
macro

No problem if I run it in Access 2007.
Click to expand...
Click to expand...
Click to expand...
 
Thanks Allen..Uninstalled and Reinstalled seems the one that worked.


--
H. Frank Situmorang


Allen Browne said:
Assuming this is an MDB (not an MDE), it should work okay.

If no other databases work under A2002 either, then a reinstall would be
worthwhile. But if other databases (such as Northwind) do work, then a
decompile might solve it.

Try the steps suggested here:
Recovery Sequence
at:
http://allenbrowne.com/recover.html

Use Access 2002 to do the compacting and decompiling.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Frank Situmorang said:
Allen,

I have checked the reference, it is neither the problem of reference nor
the
limited user of Winxp. I run it on my own laptop, not the company's
computer.

In my laptop, I have 2 version of Office which are ver 2002 and 2007.
there
is no problem if I run it with ver 2007. There is problem for ver 2002.
Since
I want to distribute my denomination chruch secretary database whose
versions are mostly 2002, that is why I want it run in ver 2002.

Do you think I need to uninstalled my ver 2002 and reinstall it again?.

Thanks if you still can help me.

--
H. Frank Situmorang


Allen Browne said:
Check your references are okay:
http://allenbrowne.com/ser-38.html

If that is not the issue, perhaps it is permissions. For example, if you
are
now logging into WinXP as a limited user rather than a local computer
administrator, it could be this issue that turns up in Vista too:
http://allenbrowne.com/bug-17.html

Hello,

Previously I can open my database in access 2002 and 2003 but
since my laptop crash and I reinstalled my Windows Xp, when I
run my database in Access 2002, the erroe message is:
The espressseion on timer you enterred on the event prperty
setting produced the following error: object or class deos not the
set of event. * the expression may not result in the name of a macro,
the name of a user defined function. or [event Procedure]
* There may have been an error evaluating the function, event, or
macro

No problem if I run it in Access 2007.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top