Home > Archive > MS Access data conversion > April 2005 > MS Access 97 to 2003 Conversion Problem Encountered









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author MS Access 97 to 2003 Conversion Problem Encountered
Ghost Surfer

2005-04-06, 8:05 pm

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!


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com