• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

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

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
fishwm
Asked:
fishwm
1 Solution
 
broesiCommented:
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
 
stevbeCommented:
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
 
fishwmAuthor Commented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
broesiCommented:
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
 
Steve BinkCommented:
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
 
moduloCommented:
PAQed with points refunded (100)

modulo
Community Support Moderator
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Tackle projects and never again get stuck behind a technical roadblock.
Join Now