Can someone recommend the best way to either:
1) How to create an Access 97 database so that future migration to an SQL
Server database is painless...such that all tables, forms and reports
created in Access are easily migrated,
2) the easiest way to migrate the Access 97 tables (and their
relationships), and forms/reports created in Access so that they can be
translated and leveraged into a web page format so that they look and act
the same way as they do in Access 97 but in SQL Server 2000.