Create an Access Project to manage an SQL Server database
Many ASP developers are used to building databases with Microsoft Access. But, when it comes to managing an online SQL Server 2000 database, some developers can be unused to the Enterprise Manager. The Enterprise Manager is built into SQL Server and is used for accomplishing management tasks on the remote database. However, some may find an Access Project more friendly in managing the SQL database.
Open Microsoft Access and create a new project by going Ctrl-N. Then select Project (New Data). Choose a location and a filename for the project. Next, when you see the wizard below, click Cancel.
So, now we have a blank Project. Next, go File > Connection. You can now add the server name of the remote SQL Server (normally an IP address or a machine name). And also the username/password to give you access to the database.
Then click OK and you will now be able to manage a remote SQL server database using the familiar Access tools.
