Converting A2K to Access 2003 and back again?

[Paul Burdett]

Hi Guys

I had an A2K application that I have successfully deployed on lots of
machine using the PDW. If the target machine already had Access, no problem.
If it didn't, it installed runtime and all was well.

I then coverted the application to Access 2003. All was well until I
packaged the new version using PDW and installed it on machines with A2K
already resident. The application installs OK but when I try to open it
complains that the database format is unrecognisable.

Reading though newsgroups there seems to be a whole bunch of compatibility
issues between an Access 2003 application and earlier versions of Windows
and Access.

Unless I can find a way round this then it seems to me that I have to take
the application back to A2K.

So my question is - is this the way forward and is there a utility that can
help me do it or is there another approach?

Thanks in advance.

Paul

 

[Douglas J Steele]

You mention "earlier versions of Windows". Access 2003 will only work with
Windows 2000 (SP3) or newer.

Not sure what conversion you're looking for help with, though. Access 2003
and Access 2002 share the same file format (and, actually, both default to
the Access 2000 file format)

 

[Paul Burdett]

Hi Douglas

Thanks for this.

My problem is that I have to deploy the application on all sorts including
Win95, 98, NT, W2K, & XP and these may already have resident a version of
Office/Access that may cause problems as I understand it.

At the moment I am copying the Access 2003 version back to a machine with
A2K, changing the references, recompiling it and then packaging it with PDW.

This means I can't use any Access 2003 features and this is not a very
elegant solution. I was wondering what other options there are.

Kind regards

Paul