Access 2002 - 2003 problem

A

aj

I have a access db that was created and working fine with
access 2002. I opened the database with access 2003 it
seemed to work fine with no errors and closed the
database. When I now open the database with access 2002
and try to run a form, I get a "Undefined
function '$RTrim' in expression" error message. Is this
a known problem? Is there anything that I can do to the
database so that I can use it again with Access 2002?
Thanks
aj
 
D

Dirk Goldgar

aj said:
I have a access db that was created and working fine with
access 2002. I opened the database with access 2003 it
seemed to work fine with no errors and closed the
database. When I now open the database with access 2002
and try to run a form, I get a "Undefined
function '$RTrim' in expression" error message. Is this
a known problem? Is there anything that I can do to the
database so that I can use it again with Access 2002?
Thanks
aj
Click to expand...

Check for broken references using the steps outlined here:


http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

I believe that Access 2003 will have updated the references to certain
libraries to the Office 11 version, and now you may have to manually
correct these references back to the Office 10 version.
 
S

sathyam1968

First open the database in Access 2003 and then
follow the following steps
1) Tools -> Compact and repair Database
2) Tools -> Database Utilities -> Convert Database -> To Access 2002 - 2003
File format

Save the database into a new mdb file

After this convert try opening the database in access 2002.

B.Sathyamurthy
*********************
 
Top