Converting an Access97 database to Access2000

[chicks]

We are moving to a new server that will now have Windows and Office 2000 from Windows 95/98 and Officer97.
In our Access97 databases the Date() function has been used extensively. Upon converting a database to Access2000 if gives us an error and does not recognize the function Date().
If I change the function to be Now() instead, it has no problem.
Do you think our problem is within Access2000 or within Windows2000?
Help!!

 

[Travis]

Look at your "references". When ever you start loosing simple built in functions, your references are usually to blame. You may have a missing reference or just need to unselect one and reselect it to refresh the reference list.

 

[chicks]

Travis,
What do you mean by "references". Do you mean libraries that need to be installed?

 

[bbeeching]

We did the same thing last year, I was tagged to convert several db's that were written in Access97. Travis is correct. Open a module or a form in design view, check the properties dialog to see if the form has a module, if it does, find the icon on the menu bar that says "code" (when your pointer passes over it) click on it, when the module opens choose "tools" if you are in Access97 or "Debug" (I think) in 2000. and then find "References" a list will pop up, look for a choice that say's ?Extensibility 3.1 or something simular. I'm sorry I can't tell you exactly, I'm at home on Access97 so I can't remember exactly, but try choosing a few. you won't hurt anything, you'll just get a little fustrated at first. but the majority of such problems can be solved here. Also after you convert you may find that your reports won't run, you'll generate one of those errors that Microsoft was so kind as not to identify..if that happens make sure that the PC or each user has a printer set up in their profile. Evidently Access2000 looks for the printer BEFORE it opens the preview. I hope this helps.

Brad.