Access 97 project will not run

[me1258]

Hi

I have an access 97 project that someone else wrote some time ago.

I need to install this program on a new computer for someone.

They want access 97 installed on the new machine also

This "file" is just a .mdb file that they are using.
no install stuff....

When I open the file on my machine, P4 with XP pro and running Office XP
if opens to an error.

The error is that on load the program is loading global variables with prices.

I can see the table with the rate in it... I can see the form and everything else but it will not work....non of it will for that matter...I know this is very vague but I dont even know where to start figuring this out.

Obviously the dynaset is not opening properly...it has been a long time since I messed with this stuff...any suggestions.

I see no connections any where on this DB>

Thanks

 

[Calvin]

Since your opening a 97 mdb in 2002 there could be any number of problems, you need to install Access 97 and open it with that to see if there is any real problems, other than version differences. goto MSDN and look up changes between 97 and 2000. If you convert the 97 to 2000 or 2002 you will still most likely have to go back and rewrite several functions/processes to mirror the changes in Access versions.

 

[WayneRyan]

Me,

Do a search on this forum for references. The Access 97 app probably uses
DAO, and the newer version expects ADO.

You can look at declaring things as DAO and including a reference to it.

Wayne

 

[me1258]

Ok Thanks

Ok thanks
It's a start

Me,

Do a search on this forum for references. The Access 97 app probably uses
DAO, and the newer version expects ADO.

You can look at declaring things as DAO and including a reference to it.

Wayne