Hans,

Thanks for that.

I have searched and read lots of messages in the forum and read the MS whitepaper on access conversion and converted about a dozen systems of various complexity to XP.

No what I am doing is trying to develop a tool to first identify possible problem databases in 97 and then to convert and flag databases that have conversion problems.

I don’t know that I will be fixing DAO syntax as part of the batch, I suspect that if there are any user built systems with DAO code I will probably want to have a look to determine what the system does.

As the tool will be given to end users,help desk personnel, and floor walkers during the roll out as a first line of anaylsis I’m just trying to determine if there are any other things that I can check and fix via batch processing.

I know my most important result from this tool (as the second line of support) will be the log of systems processed and those flaged for manual intervention.

Stewart

Hans,

Thanks for that.

I have searched and read lots of messages in the forum and read the MS whitepaper on access conversion and converted about a dozen systems of various complexity to XP.

No what I am doing is trying to develop a tool to first identify possible problem databases in 97 and then to convert and flag databases that have conversion problems.

I don’t know that I will be fixing DAO syntax as part of the batch, I suspect that if there are any user built systems with DAO code I will probably want to have a look to determine what the system does.

As the tool will be given to end users,help desk personnel, and floor walkers during the roll out as a first line of anaylsis I’m just trying to determine if there are any other things that I can check and fix via batch processing.

I know my most important result from this tool (as the second line of support) will be the log of systems processed and those flaged for manual intervention.

Stewart

Wendell,

The issue of version is a good one and I think we are happy with te 2k format.

I was aware of the “The Access Conversion ToolKit” as I found reference to it in a search here. I got very excited and if it was available now it would be just what I need. But released later this summer (winter for us) isn’t specific enough for me to rely on it becoming avaialable within a time frame that is useful.

Thanks for taking the time to reply.

Stewart

Wendell,

The issue of version is a good one and I think we are happy with te 2k format.

I was aware of the “The Access Conversion ToolKit” as I found reference to it in a search here. I got very excited and if it was available now it would be just what I need. But released later this summer (winter for us) isn’t specific enough for me to rely on it becoming avaialable within a time frame that is useful.

Thanks for taking the time to reply.

Stewart