K
Keith
I am having some serious challenges migrating a major application from
A2k to A2007.
I am using a A2000 mde front end and mdb backend
In each scenario listed below, Trusted Locations are properly set and
no Missing Reference errors are generated.
This is what I am facing:
- If I run the A2000 frontend app as mdb or mde under A2007 and WinXP,
everything runs fine. When I run the A2000 mde under A2007 and WinXp,
the A2007 ribbons do not appear and my custom menus appear. (That is
what I want.)
- If I run the A2000 front end mdb on A2007 and Vista, it runs fine
- If I run the A2000 frontend mde on A2007 and Vista, it appears to
choke on certain VBA functions (e.g., right) using in queries. There
are not any missing references.
Converting to ACCDB. I converted the frontend to accdb format.
(Trusted Location SET)
- Running the frontend accdb on A2007 and WinXP. It runs fine, but the
A2007 ribbons appear and my custom menus are under add-ins. (I want
the ribbons to stay hidden)
- I have an autoexec macro that runs, checking references, backend
file location, etc. Running the frontend accde on A2007 and WinXp
results in an error. "The expression you entered has a function name
that <myappname> cannot find." I am quite sure it is not a program
error because I have status messages for each step of the autoexec
macro; none of the status messages show. When I click OK, I get the
macro Action Failed window, with error 2950. It seems that the macro
cannot find my VBA startup() routine.
This error appears to be the same as the one discussed but not
resolved in the following thread
http://groups.google.com/group/micr...?lnk=gst&q=accde+menu&rnum=2#504b296ee4f8d93c
Anyone faced this?
Any suggestions as to how to resolve this?
Keith
A2k to A2007.
I am using a A2000 mde front end and mdb backend
In each scenario listed below, Trusted Locations are properly set and
no Missing Reference errors are generated.
This is what I am facing:
- If I run the A2000 frontend app as mdb or mde under A2007 and WinXP,
everything runs fine. When I run the A2000 mde under A2007 and WinXp,
the A2007 ribbons do not appear and my custom menus appear. (That is
what I want.)
- If I run the A2000 front end mdb on A2007 and Vista, it runs fine
- If I run the A2000 frontend mde on A2007 and Vista, it appears to
choke on certain VBA functions (e.g., right) using in queries. There
are not any missing references.
Converting to ACCDB. I converted the frontend to accdb format.
(Trusted Location SET)
- Running the frontend accdb on A2007 and WinXP. It runs fine, but the
A2007 ribbons appear and my custom menus are under add-ins. (I want
the ribbons to stay hidden)
- I have an autoexec macro that runs, checking references, backend
file location, etc. Running the frontend accde on A2007 and WinXp
results in an error. "The expression you entered has a function name
that <myappname> cannot find." I am quite sure it is not a program
error because I have status messages for each step of the autoexec
macro; none of the status messages show. When I click OK, I get the
macro Action Failed window, with error 2950. It seems that the macro
cannot find my VBA startup() routine.
This error appears to be the same as the one discussed but not
resolved in the following thread
http://groups.google.com/group/micr...?lnk=gst&q=accde+menu&rnum=2#504b296ee4f8d93c
Anyone faced this?
Any suggestions as to how to resolve this?
Keith