Yes, you can open the database using MS Access, but it must be done by creating an ODBC Connection. It is very important that you do not change any records in the CW_Data file through MS Access. Any changes to the data should be done either through the CAREWare client, or by using the business tier programming interface.
If you are not familiar with creating ODBC connections, follow the instructions listed below:
- Start MS Access and click File>Open
- Change the file type drop down box to “ODBC connections”. This should bring up a new window.
- Click the “Machine Data Source” tab and then click “New”.
- Click the “System Data Source” button and click “Next”.
- Scroll down to “SQL Server” and click “Next”.
- Click the “Finish” button. Now you will see the “SQL Server Data Source Connection” wizard.
- Type in a name and description for this connection, and then choose the server from the list.
- Use “Windows Authentication” (which uses your Windows ID and Password to Login). If this doesn’t work, you may need to try “SQL Authentication”.
- Change the default database to CW_Data.
- Click “Finish”. Now when you open MS Access and change the type to ODBC you will see the connection you just created.
Back to the
Data TierBack to
Frequently Asked Questions