N
Nikos Yannacopoulos
I have a A2K3 .mde front-end (converted from a previous A2K), which has
been in use for years. Now that the organization has upgraded to Office
2K7, I converted the .mdb to accde and it runs fine. I make an .accde
from it, and ran into problems! The original version used an autoxec
macro to run some code at start-up, which is OK with the .accdb, but
creates a 2950 error in the .accde.
I've searched and found proposed solutions, which did not work (trust
did not resolve it, 3rd party .exe utilities which supposedly fix it in
the registry are not accepted by the company policy, and I don't trust
them anyway).
So, I thought I'd give up on the autoexec macro, and use a form's Load
event... I created a dummy form just for the purpose, which does the job
just fine in the .accdb. I created the .accde, and the code in the Load
event (or the Open event for that matter) won't fire! The very first
line of code is a simple msgbox, so I know the event has kicked in, it
works in the .accdb, it does not in the .accde.
Anyone seen this? Any suggestion how to go about it?
TIA,
Nikos
been in use for years. Now that the organization has upgraded to Office
2K7, I converted the .mdb to accde and it runs fine. I make an .accde
from it, and ran into problems! The original version used an autoxec
macro to run some code at start-up, which is OK with the .accdb, but
creates a 2950 error in the .accde.
I've searched and found proposed solutions, which did not work (trust
did not resolve it, 3rd party .exe utilities which supposedly fix it in
the registry are not accepted by the company policy, and I don't trust
them anyway).
So, I thought I'd give up on the autoexec macro, and use a form's Load
event... I created a dummy form just for the purpose, which does the job
just fine in the .accdb. I created the .accde, and the code in the Load
event (or the Open event for that matter) won't fire! The very first
line of code is a simple msgbox, so I know the event has kicked in, it
works in the .accdb, it does not in the .accde.
Anyone seen this? Any suggestion how to go about it?
TIA,
Nikos