Error opening Access 2003 Form in Access 2007

[Shalini]

Hi,

I have a working application in Access 2003. It has reports which open
on some criteria selection. The criteria selection is done on choosing
criteria from combo box which is on the Form.

This section of reports works fine when I choose any report to run in
Access 2003 but when I run the same application in Access 2007. it
fails to find the form on which combo box appears. It gives me
microsoft office error "The expression you entered has a function name
that the application can't find" .then gives the microsoft visual
basic error "Application can't find the Form "formname" reffered to in
a macro expression or Visual Basic code".

I checked for all the references in the application no missing
references. Please help what else can I check for in order to resolve
this error.

Thanks in advance,
Shalini

 

[Allen Browne]

Is this running under Windows Vista?
Or does the user have limited priviliges (even under XP)?

If so, it may be a matter of not being able to register the correct library
to run the code. Details in:
Errors using multiple versions of Access under Vista
at:
http://allenbrowne.com/bug-17.html

 

[Shalini]

Thanks for replying Allen. The application is residing on the shared
location and some users are using Vista/Access 2007 and some users are
using XP/Access 2003 to open it.

Actually the application was working fine a month ago. but recently
one user using Access 2007 had this problem of not being able to open
the form and then other Access 2007 users also had the same trouble.
but the same application runs fine on Access2003/XP machine.

What can be the reason?

Shalini

 

[Allen Browne]

I hope you did follow through that possibility.

If that doesn't solve the issue, a decompile might.
Follow these steps for recovering a problem database:
http://allenbrowne.com/recover.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks for replying Allen. The application is residing on the shared
location and some users are using Vista/Access 2007 and some users are
using XP/Access 2003 to open it.

Actually the application was working fine a month ago. but recently
one user using Access 2007 had this problem of not being able to open
the form and then other Access 2007 users also had the same trouble.
but the same application runs fine on Access2003/XP machine.

What can be the reason?

Shalini