?
Solved

Access 2000 has a error message "438 Object doesn't support this property or Method"

Posted on 2004-10-11
7
Medium Priority
?
213 Views
Last Modified: 2006-11-17
Hi experts,

I had a Office XP installed in a PC. Then I install the Access 2000 on the same PC. When I start the Access 2000. A error message come out : "438 Object doesn't support this property or Method"

How to solve?

Thanks
0
Comment
Question by:fishwm
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 5

Expert Comment

by:broesi
ID: 12274629
Do you mean

1. the error message shows up as soon as you open Access itself, without an mdb-file
OR
2. are you opening an MDB-file?

If (1), then I would suggest to deinstall Access XP and 2000, then install Access 2000 and then Access XP (into different folders!)

If (2): if the error message has a 'debug'-button, click on it and tell us the yellow marked line

broesi

0
 
LVL 39

Expert Comment

by:stevbe
ID: 12275084
My guess is that you opened a database that has a startup form that has some code that uses the DAO object library and eiter the reference is Missing or the code is not explicit enough and VBA is try int o use the ADODB recordset instead of a DAO recordset. There are a couple of things to do ... 1 Go into the code and change

Set rstXXX   As Recordset
to
Set rstXXX   As DAO.Recordset

now debug --> compile form any code window.

if you still have a problem then open the references dialog box (Tools --> References menu) and make sure to check Microsoft DAO Object 3.6 Library

Steve
0
 

Author Comment

by:fishwm
ID: 12284064
All,

I didn't open any database. And the office XP did not include the Access XP. The PC only have Word XP, Excel XP and Powerpoint XP and I install the Access 2000 within the same PC.

Ray
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 5

Expert Comment

by:broesi
ID: 12284686
Just a guess: try to install the latest MDAC!

currently available at:

http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en
0
 
LVL 51

Expert Comment

by:Steve Bink
ID: 12885599
Do not accept this as an answer.

First, take a look at this PAQ:

http://www.experts-exchange.com/Databases/MS_Access/Q_21159613.html

It's not quite the same issue, but the final resolution from Microsoft very much applies to your scenario.  By installing two different versions of Office, you are creating a version conflict, especially since you are installing only parts of Office 2002/XP combined with parts of Office 2000.  It does not really matter if you pick different folders (or even different drives!) for the installs, since the files causing the issues will be copied to the common folders all versions use.

Whatever your reason for installing two partial versions of Office, re-evaluate them.  It is most definitely not recommended practice, as you have already seen some of the issues you can expect.  Stick to one version...Lowest Common Denominator...
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12902936
PAQed with points refunded (100)

modulo
Community Support Moderator
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question