DV1023 - Microsoft Access displays #Deleted in all fields

The information in this article applies to:

• DOVICO Timesheet version 8 and higher

Symptoms:

• After creating a live link to Microsoft Access all fields display #Deleted.
• After upgrading to a newer version of DOVICO Timesheet or Track-IT Suite, Microsoft Access fields display #Deleted.

Cause:

This occurs because Microsoft Access does not support the BigInt data type from Microsoft SQL Server 2000 and Microsoft Database Engine 2000.

Workaround:

To workaround this situation an SQL view must be created for each table in the database. Please follow the instructions below to create views for each table.

IMPORTANT NOTES:

• The following steps must be performed on the server where the DOVICO Timesheet/Track-IT pro database is located.
• The .vbs script should be run after any upgrade of DOVICO Timesheet or Track-IT Suite.
  1. Download the createviews.zip file from http://www.dovicofiles.com/createviews.zip
  2. Extract the CreateViewsAllVersionsForAccess.vbs file to a temporary directory.
  3. Open the file in Notepad.
  4. Edit the text highlighted below.
     • Change the sDatabase value from YourDatabaseName to the name of your database.
     • Change the sServer value.
     • If you are using a full installation of Microsoft SQL Server 2000 or 2005, change the sUserID value from sa to the User ID used to connect to SQL Server/MSDE.
     • If you are using a full installation of Microsoft SQL Server 2000 or 2005 or have changed your sa account password, change the sPassword value from dovico to the password used to connect to SQL Server/MSDE

  

  5. Save the file and close Notepad.
  6. Double click the CreateViewsAllVersionsForAccess.vbs file to create views for each table.

  Once the steps above have been completed. You will be able to view the information in the database by opening the view that represents the corresponding table. All views will begin with dbo.ACCESS. For example: the employee view will be shown as dbo.ACCESS_EMPLOYEE.

  IMPORTANT: When creating the live link with Microsoft Access please ensure that you do not select a Unique Identifier for any view that you are linking.

  When you receive any message boxes similar to the one below. Do not select any record as the Unique Identifier, just click OK to continue.