MS Access 2003 VBA Compatibility

  • Thread starter Thread starter Siegfried Kaelbert
  • Start date Start date
S

Siegfried Kaelbert

Dear All,
I programmed a large database (65,000 records) in MSAccess
2000. I added a lot of event procedures to the forms in
order to display the contents of tables and queries as
desired. Under Office 2000 these procedures work properly.
Now I changed to Office 2003 and got MSAccess 2003 on my
computer. I had to experience that now these procedures
added to the forms and e.g. text boxes do not work
anymore. when these procedures are called a large fault
message is displayed. The form will be shown without the
data to be filled in by the procedures.
Is there a solution to overcome the problem or is Access
2003 not downwards compatible?
Thanks and best regards
Siegfried
 
Hi Siegfried,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.

I am not sure of the exact error message you get, however, it sounds like
you might have a missing reference or if you use dao code, you need to make
sure that the dao library takes precedence over the ado object library, as
it is not checked by default for new Access 2003 databases.

To check, open your database and go to Modules. Click New to create a new
module. This will open the Visual Basic Editor window. Go to Tools,
References. Uncheck any checked references preceeded by the word
"missing". Also, look at the references that are checked. Do you see a
reference to the Microsoft DAO 3.6 Object Library checked? If not, look in
the list, check it, and put in anywhere in the list above the ActiveX 2.1
reference. Click ok, then close and save the module. Now test your code.
See if you get any compile errors.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.
 
Hi Amy,
Thank you very much for your advises. I'll check that on
Saturday because I live in Saudi Arabia and there is the
weekend on Thurday and Friday.
At home I work with Access 2000 so that these problems do
not occur. At work our company has provided us with
Office 3000 and the problems started with the new version.
It is true, there is a message informing me that either
the links to DAO or to ActiveX are disturbed.
I'll check your avices. I know for sure how to open the
VBA Editor. Also how to handle the references is known.
The problem was that I did not see a context between my
problem and the references. But after your answer it is
now clear and I think this will solve the problem.
I'll inform you about the results.
Thanks and regards
Siegfried
 
Back
Top