Windows 7, 64-bit Access 2003 Problems (1 Viewer)

A

access2010

Registered User.

Local time

Yesterday, 23:19

Joined

Dec 26, 2009

Messages

1,021

• Oct 19, 2013

• #1

On a new computer I have installed Windows 7, 64-bit O/S and then installed Office 2003 to run MsAccess and Outlook.

Upon running our Access2003 .MDB and .MDE email application, and using the code to send smtp email to Outlook is not working and I get this error message "The expression On Open you entered as the event property setting produced the following error: Object or class does not support the set of events."

To see if I could fix this problem, I created a blank database and imported all of the items into the new database and still received the same error. (On our XP machines we never have any errors)

Any suggestions will be appreciated.

 

Attachments

• Access_Forum_2013Oct18.doc

  34 KB · Views: 182

missinglinq

AWF VIP

Local time

Today, 02:19

Joined

Jun 20, 2003

Messages

6,423

• Oct 19, 2013

• #2

The Access Gnomes, of course, are not noted for the appropriateness or usefulness of their error messages! Anytime apps run fine on one machine and not on another, especially one that has just had Access installed, one the first things you have to think about are Missing References.

If you haven't checked for this kind of thing before, here are Doug Steele's detailed instructions on how to troubleshoot the problem:

Access Reference Problems

Linq ;0)>

 

J

JHB

Have been here a while

Local time

Today, 08:19

Joined

Jun 17, 2012

Messages

7,732

• Oct 20, 2013

• #3

AccessBlaster said:

.. I suspect Windows 7 64bit no longer supports a 10 year old Access program. Just my 2¢.

Click to expand...

Windows 8 does run with an MS-Access 2000 (Office 2000) installation, no problem.

 

A

access2010

Registered User.

Local time

Yesterday, 23:19

Joined

Dec 26, 2009

Messages

1,021

• Oct 21, 2013

• #4

Thank you for your suggestion.

All the references have been checked and show no errors.

I just purchased my Windows 7 O/S a week a go and to purchase Windows 8 O/S now seems silly.

Paul

 

pr2-eugin

Super Moderator

Local time

Today, 07:19

Joined

Nov 30, 2011

Messages

8,494

• Oct 21, 2013

• #5

Okay try Late Binding of Objects.

Some information on Late Binding.
http://www.granite.ab.ca/access/latebinding.htm
http://support.microsoft.com/kb/245115

 

A

access2010

Registered User.

Local time

Yesterday, 23:19

Joined

Dec 26, 2009

Messages

1,021

• Oct 23, 2013

• #6

Thank you for your suggestions which we will try.

Paul

 

C

ct2013

Registered User.

Local time

Today, 07:19

Joined

Jun 6, 2013

Messages

87

• Oct 23, 2013

• #7

I had a similar problem when if had to install access97 on my windows 7 with Microsoft 2010

I kept having trouble the whole time, I found out if you first install the older version and only then install the newer version of MS it is usually ok, and this helped me.

 

A

access2010

Registered User.

Local time

Yesterday, 23:19

Joined

Dec 26, 2009

Messages

1,021

• Oct 23, 2013

• #8

Thank you for your suggestion, but this has not corrected my problem.

Paul

 

D

DJkarl

Registered User.

Local time

Today, 01:19

Joined

Mar 16, 2007

Messages

1,028

• Oct 23, 2013

• #9

Have you stepped through the code on the MDB yet? What line is the error on?