Conversion issues: Access front end vs. ODBC back end

[lewaah]

Greetings!

My issue is this: My office uses Access 97 and I have
designed an application that uses an Access 97 front end
to execute inserts and updates through an ODBC link to
Oracle tables on the back end. Recently, some of our
people have gotten Access 2000 or 2002 installed and still
need to use the application. Obviously, they can convert
the Access front end to whatever version they have
installed. My question is, since the back end is in
Oracle via ODBC link and not in Access, will they still be
able to connect to the ODBC tables after they convert the
front end? Seems like this is just a regular front
end/back end type conversion, but the tables being Oracle
instead of Access is throwing me, and I'm looking for a
little reassurance. Thanks in advance for any advice!

 

[Tim Ferguson]

Obviously, they can convert
the Access front end to whatever version they have
installed. My question is, since the back end is in
Oracle via ODBC link and not in Access, will they still be
able to connect to the ODBC tables after they convert the
front end?

The ODBC back end, if anything, reduces one level of potential complexity,
in that the SQL will not change with the level of Jet.

On the other hand, upgrading the VBA and forms is not always problem-free,
so you might want to do an upgrade and check it, and then distribute the
2000 front end in parallel.

Hope that helps


Tim F