Creating MS SQL 2000 Database with
Access 2000, XP
Microsoft Access 2000 and XP Only.
Customers with Microsoft Access 2000 and Windows XP installed on
their computer have an easy way to interface with the SQL
Server. To connect to you database and start working on it, you
a. SQL Server IP Address
b. SQL Server UserID and Password
c. SQL Server database Name
Open Access 2000 or XP, and select menu choice, "File -> New ->
Type in a name for the new project and Click on "Create"
Fill in the information requested by the "Data Link Properties"
Please Note: Server Name is the IP address of the server.
After completing the requested information, click on "test
connection" button to make sure it works.
Now you can create tables and queries as you would normally to
you have any questions:
support@ITsGroup.org or Phone 1-780-701-7282.