I just installed SQL 7 on my server and have an Access database that contains a lot of information. How do I create a SQL database?
Also, is there an easy way to port the information from Access into that SQL database?
Look for an upsizing wizard in Access to get you to SQL 7. Creating the database is a piece of cake; just right-click in Enterprise Manager on Databases, select New, and you’re on your way.