Hi,

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,

or

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.

Thanks,

Steve