While access 97 is now 4 versions old, it still does the job!
I see no reason why you cannot use Ms-access as tool to edit, update, and
yes even report data from any database server that supports ODBC.
Thus, ms-access should work just fine with
sql server
Oracle
Sybase
MySql
etc. etc. etc......
In all of the above cases, you should not need to import the data. Last time
I looked, MySql did not have views, and thus you DO NOT want to try and use
sql that joins two tables via linked tables. You should create a
pass-through query in those cases.
However, standard linked tables should let you edit, and reprot on data on
server based systems.
