Hello Charles:

Thanks for your offer to help.

My table structure is :

CREATE TABLE [tbl_group] (

 [StaffID] [int] NULL ,

 [TrackOrderID] [int] NULL ,

 [Qualifier] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [LSeries] [int] NOT NULL ,

 [LSeriesunit] [int] NOT NULL ,

 [Image_Filename] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [Display_Image] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [Page] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [Sort_Order] [int] NULL ,

 [URL_Path] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [File_Size_Bytes] [int] NULL ,

 [Daily_RHD_No] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [Daily_Date_Transferred] [smalldatetime] NULL ,

 [Archival_RHD_No] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [Archival_Date_Transferred] [smalldatetime] NULL ,

 [Storage_Array_Transfer] [smalldatetime] NULL ,

 CONSTRAINT [PK_tbl_group] PRIMARY KEY  CLUSTERED

 (

  [Qualifier],

  [LSeries],

  [LSeriesunit],

  [Image_Filename]

&nbsp WITH  FILLFACTOR = 90  ON [PRIMARY]

The ACCESS program does the following:

1. The data in this table is tranferred to SQL server .

2. a stored procedure from SQL server is called that does the following: