G
Ghost Surfer
Hi all!
This is really weird, at least for me.
This is my problem. I am currently trying to upgrade our MS Access 97
Accounting application to MS Access 2003 without changing the codes at all.
The application's database is separate from the program. So, the
application, when it runs, attaches the database to the program. This is the
setup. This is why when I upgrade them separately, I get a warning message
when I upgrade the application part in relation to linking the tables
properly. After the upgrade, what I do is, I run the program MDB and select
the option "Link Manager" option to fix the warning I encountered during the
upgrade phase. I got a successful message back.
Here is where the problem starts. When I run the application and select one
of the option menus (actually the menus are just a bunch of buttons for each
function) and run one of its functions (e.g. "Bills" form). And once there,
click the next navigation button at the navigation bar (the button that show
">"), it pops out this "Error # 94" message.
Now, this would not be an unusual error for me but the thing is, this error
does not pop out under MS Access 97. It only pops out when it is converted
to MS Access 2000 or MS Access 2003.
Is there an issue with regards to codes in MS Access 97 running well and not
running well in MS Access 2000-2003? Why is it not popping out under 97 and
popping out under 2000 or 2003?
I really appreciate the input.
Thanks!
This is really weird, at least for me.
This is my problem. I am currently trying to upgrade our MS Access 97
Accounting application to MS Access 2003 without changing the codes at all.
The application's database is separate from the program. So, the
application, when it runs, attaches the database to the program. This is the
setup. This is why when I upgrade them separately, I get a warning message
when I upgrade the application part in relation to linking the tables
properly. After the upgrade, what I do is, I run the program MDB and select
the option "Link Manager" option to fix the warning I encountered during the
upgrade phase. I got a successful message back.
Here is where the problem starts. When I run the application and select one
of the option menus (actually the menus are just a bunch of buttons for each
function) and run one of its functions (e.g. "Bills" form). And once there,
click the next navigation button at the navigation bar (the button that show
">"), it pops out this "Error # 94" message.
Now, this would not be an unusual error for me but the thing is, this error
does not pop out under MS Access 97. It only pops out when it is converted
to MS Access 2000 or MS Access 2003.
Is there an issue with regards to codes in MS Access 97 running well and not
running well in MS Access 2000-2003? Why is it not popping out under 97 and
popping out under 2000 or 2003?
I really appreciate the input.
Thanks!