Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  MS Access to SQL Server 2000

Author  Topic  SKIBUM Starting Member 32 Posts Posted - 2001-09-27 : 17:42:12 All: I have an Access 97 Database. The database contains various tables, forms, reports, and user security settings. Can you give me some guidance as to what the best route would be to up the Access database to SQL Server 2000? 1. Would an ASP solution be the best way to implement the existing Access Forms? 2. What would be the best solution to move the existing reports to the web server. 3. Can you point me to some info on implementing Access like security on the SQL Server/new Apps. Thanks for your help.