Conversion from A97 to A2k

[Peter Bellamy]

I have just started converting a fairly large database program from 97 to 2k and on conversion it has warned that it will not compile. I assume it will be because of code variations between the two versions.
My first check showed it did not like Error$ and wanted Err.description, no problem, found and replaced all instances.
The next one it complained about was Str(). "Cannot find project or library" an OK takes me to the references page where it has the first 6 entries checked.

Do I need to select another reference library?

Is this just the start of a long list of 'errors' ?

Should I ever have started !!!

Any suggestions will be welcomed.

Thanks

Peter

 

[ghudson]

Did the db compile before you converted it?

You should only have to check for missing references in the conveted db and just reselect them.

 

[Ian Mac]

You say it has the 1st 6 entries checked, what are they and do any of them have 'missing:' in front, I'm guessing not as you haven't mentioned it.

I'm bst qualified at VBA in Access, but it seems Str() isn't part of 2003 which I have on this machine.

You can use Format()

Again not qualified but hopefully someone can back me up but I believe WhatEver'$' isn't a convention used much anymore and maybe (he said tentitively) being removed from later versions of VB/VBA. I'm sure I'm wrong on that part but something I read recently said it was not needed for optimisation anymore.

As for is it worth it? Yes, I am currently having to convert 4 applications to 2003 so they work on Access runtime (no errors get fed back, nothing you can do about them anyway) from 97. Spending lots of time in the Testing lab (oo get him), but I am learning so much and that by itself is wirth it, every bleedy error.

Hope that kinda helps.

PS. check your Access constants, a few have changed from 97 to 2000 as with Excel, Word etc. use the acLinkDelim not 5 in your programming (this is not one which has changed BTW but I cannot find the list currently).
I'll add a link when I have it.

Cheers,

 

[Peter Bellamy]

Thanks for your replies.
Yes it compiles under A97 without errors.

The Libraries ticked (without a 'missing' beside them) are:
Visual Basic for applications
M'soft Access 9.0 Object Library
OLE Automation
M'soft Visual Basic for Applications Extensibility 5.3 (Thats a catchy one!)
M'soft Office Web Components 9.0
Cheers

Peter

 

[Peter Bellamy]

Solved it!
Not that familiar with A2k and the Visual Basic Window but found that there is an object browser and it allows you to examine the contents of the dll's. A search for Str showed it in VBA. I just then moved VBA up the references list and it compiled immediately !
I am sure there must be a reason, but why the order in the references list is important baffles me. If there was more than one occurence and they were different ok, but for a simple thing like Str ???
I am sure someone will have a good reason.

Peter