I'm attempting to upsize an Access 2002 database (Access 2000 file format) to SQL Server 2000, and when I do the resulting ADP file is missing all the forms. I can import them from the original MDB file, but I rather solve the real problem of why they go missing in the first place.

Also, other users see the tables with my user name prefixed to them, e.g. scony.tblCategory, or tblCategory (scony) in the database window. Is there a way for this not to happen?