Creating a Database Project in VS 2005 - Creating a new reference database (Page 2 of 4 )
Instead of using the existing references, let's add a new reference. The new reference will be working with a Microsoft Access database on a remote server. The database MDB file is on another machine, XPHTEK. Click on the Add New Reference... button. This opens up the window shown next, with SQLClient as the default datasource. SQL Client is good for SQL 2005 server, but is not for an MS Access Jet Database.
Click on the Change... button. This opens up the window Change Data Source with MS SQL Server as the default. Change it to Microsoft Access Database File and click OK.
The wizard then opens the New Database Reference window, where you need to locate your mdb file. Click on Browse to locate the mdb file. It first opens the C:My Documents folder.
You navigate through your folders on your machine and locate the shared drive which points to the nwind.mdb file on a network share as shown.
Click on the button Open which takes you back to the New Database Reference window, now showing the Database File Name: C:HtekSharenwind.mdb. You may test the connection as no password is needed. Click OK and you will have created a new reference; the Add Database Reference window shows up again, as shown, and now includes the newly added reference.
Click OK to this. The TestoleDb project will now appear in the solution explorer as shown. It also shows the folder structure. It has three folders, Change Scripts, Create Scripts, Queries and the database reference you added recently to the Database References directory.
Next: Creating a new query >>
More Database Articles
More By Jayaram Krishnaswamy
/ 10 
