Microsoft Access Admin

How to Change the Registry Permissions

  1. Start Registry Editor (Regedt32.exe).
  2. Select the following key in the registry: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
  3. On the Security menu, click Permissions.
  4. Add the internet user and type the required permissions for the account that is accessing the Web page.
  5. Quit Registry Editor.

How To Set a System DSN

  1. In Control Panel select Administrative Tools.
  2. Select Data Sources (ODBC).
  3. Select the System DSN Tab and Click 'Add'.
  4. Select a driver corresponding to the database software that you are using and click 'Finish'. This will probably be one of the following: SQL Server; an Oracle driver; or Microsoft Access driver (*.mdb).
  5. For MS Access databases: Select a Data Source Name you will assign to this connection (it can be the same as the database name or a short-hand version of the name). Although it is not required you also may enter a short description of the database in the Description box. In the Database section, click the 'Select' button to scroll to the location of your database and select it. Click 'OK'.
  6. For SQL Server databases, enter the name you wish to use to refer to this data source connection (it can be the same as the database name or a short-hand version of the name). Although it is not required you also may enter a short description of the database in the Description box. Select the SQL Server that you wish to connect to (in most instances this should be typed as: Click 'Next'.
  7. Click the check box for Windows NT Authentication. Click 'Next'.
  8. Change the default database to your SQL Server database. Click 'Next'.
  9. Click 'Finish'.
  10. Click 'Test Data Source' to ensure that a connection has been made. Click 'OK'.

How To Link a Table

  1. In the distributed file go to File->Get External Data->Link Tables
  2. Navigate to the network share or folder where the file is located and click 'Link'.
  3. In the Tables tab select the table that you want to link to and click 'OK'

References

  1. http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q295297
  2. http://support.microsoft.com/kb/305599/en-us