MDBs Made With DAO 3.5 Meet ACCESS 2002.

[Steve]

We have a number of apps written in VB6 using DAO 3.5 to create and massage
the data. Quite often, we find a need to use ACCESS by itself to
manipulate one of the tables independently of the apps.

This wasn't a problem as long as we were using ACCESS 97 across the board.
Now that A2000 is finding its way on to many--actually most--of our systems,
we can't get away with it anymore.

Surely, we aren't the first outfit to run up against this. Nevertheless, we
have to deal with it and I'm not exactly sure how to approach it.

Ideally, I would like to be able to have the apps create and maintain tables
that would be compatible in both directions with either 97 or 2002 but my
gut feeling is that it ain't gonna happen.

Any advice as to how to approach this would be appreciated.


TIA..

 

[Peter Russell]

There is an instinctive feeling of this being a problem; but can you
really identify a problem?

If you are already using Access97 to modify tables that are part of a VB
application, then surely this must be under controlled conditions. If you
were letting anybody do it at any time you would already be in the mire.

So why does matter what version of Access anybody has? In fact A2000/2
will provide more protection than with A97 since you must have exclusive
access to the mdb file to make design changes. And of course. the database
would have to be converted first. But conversion of tables between A2000/2
and A97 in A2000/2 is trivial, provided designers do not use any of the
hundreds of new features that were in A2000/2 (just a little joke!)

Perhaps I'm missing your point?

Regards

Peter Russell

 

[tina]

well, maybe i'm way off the mark here, but...
Access 2000 does not have a reference to the DAO library
automatically set, when you create a new database. i'm
only guessing that 2002 is the same.
have you tried adding the appropriate DAO library in your
db via the VBA window's Tools, References?

 

[Guest]

There's also a registry entry, NoConvertDialog (MsKb 290291) which will help
keep your A97 mdb in the current format. You'd have to get that on all your
workstations, pretty easy with a .reg file.

Steve