97 to 2002

[chris]

are verions 97 and 2002 compatible? i have both verions
and wish to use a program that was written in 97, but the
2002 version doesnt seem to want to move between pages, i
am using buttons. wondered if there is extra code 2002
needs? i have had a little access experience so can do a
little.

i have heard that 97 and 2002 version are backwards
compatible, but so far im not finding that?.

 

[Mike Painter]

are verions 97 and 2002 compatible? i have both verions
and wish to use a program that was written in 97, but the
2002 version doesnt seem to want to move between pages, i
am using buttons. wondered if there is extra code 2002
needs? i have had a little access experience so can do a
little.

i have heard that 97 and 2002 version are backwards
compatible, but so far im not finding that?.

Sort of, but I would never move that far without looking at all the code in
the database.

 

[chris]

-----Original Message-----



Sort of, but I would never move that far without looking at all the code in
the database.

it seems to access the database ok, it just wont flick
through the forms? have tried a couple of things, but got
no where, how do other people get around this, do they
just upgrade all computers, and then re-write the code?

 

[John Vinson]

are verions 97 and 2002 compatible? i have both verions
and wish to use a program that was written in 97, but the
2002 version doesnt seem to want to move between pages, i
am using buttons. wondered if there is extra code 2002
needs? i have had a little access experience so can do a
little.

i have heard that 97 and 2002 version are backwards
compatible, but so far im not finding that?.

Access2002 can open and read databases written in 97, but in order to
make any changes to the design of forms, reports, tables etc. you must
upgrade the database to at least A2000 format (2002 works equally well
with 2000 or 2002 format databases).

There shouldn't be any major changes needed. Perhaps you could open
the form that isn't "moving between pages" (do you mean between Forms?
or between tabs on a tab control? or what? Access doesn't really have
"pages") in design mode, select the button, view its Properties, and
click the ... icon by the Click event property; post the VBA code here
and maybe someone can see what's wrong.

 

[Albert D. Kallal]

My experience is that moving from a97 to a2002 is very trouble free.

In other words, I have converted some VERY extensive appcltions in a97 to
a2002. The conversion went without a hitch.

Usually problem occur in conversions when the original database in a97 was
poorly written, or in fact had,or has all kinds of problems and bugs to
begin with.

I would first test the a97 application, and make sure you can do things like
a save and compile all. This ensures that the original a97 application has
no compile errors and messy code that is un-finished, or just left hanging.
Do you do this? (one certainly cannot expect, or should even try to convert
a application with errors in it). Further, you really don't want to be
running such an application anyway.

If the aa97 application compiles ok. Then, and only then would I try
converting it to a2002. Further, I would then of course try a save and
compile all in the a2002 version.

So in my experience, the conversions have went very well indeed. Also, are
you converting, or importing the old stuff?

You should perhaps try and provide more details on that form that does not
work. When you say "move" between pages, do you mean a page control on a
form?, or do you mean moving between different forms? I will say the page
control is a very old thing, but it should still work. You are far better
off to use a tab control, and NOT a page control, but I don't see why it
don't work.