Access 97 to 2002 conversion: text in reports

[hibbie0762]

I have recently converted a couple of my Access 97 dbases to Access 2002 running under XP Pro without too much pain. The main trick seemed to be to replace the Missing Reference to DAO 3.5 with a reference to the new version (6.0?).

However my reports, which use a lot of concatenated text, are giving me hassle. I figured out that the previous format (|[datField1]| |[datField2]|) to produce the text "datField1 datField2" needs to be ([datField1] & " " & [datField2]) - ie the vertical bars have gone and the fields need to be linked with ampersands and spaces in inverted commas.

Does anyone know of a way to make the conversion automatically or will I have to make the changes manually report by report? Has anyone encountered similar issues and have you any advice to offer? All help gratefully accepted.

 

[jdegeorge]

My company had hundreds of databases to convert, so we purchased a great conversion program called OFFICE CONVERTER. Their web site is

http://www.officeconverter.com.

The program handled all of this for us, including the addition of commented lines in code showing the new and old code. It worked very well...better than XP's own conversion feature. Hope this helps.

Jim DeGeorge