by cm1jb21wdX » Fri, 13 Apr 2007 21:22:02
Listed below is the Select statement and the DDL to create the table. The
Access database connects via a linked table to this table in SQL Server and
runs the query listed below. When it connects via a linked table in another
Access database with the same number of records, it runs much faster. Is
there any way to increase the speed when it uses SQL Server. Isn't SQL
Server expected to run faster ?
SELECT ACCOUNT, CUST, DESCR, AMOUNT, PERIOD, REFNUM, INVNUM, CDATE
FROM [Local Exchange G/L]
CREATE TABLE [dbo].[Local Exchange G/L] (
[ACCOUNT] [nvarchar] (16),
[CUST] [nvarchar] (8),
[DESCR] [nvarchar] (30),
[AMOUNT] [float] NULL ,
[PERIOD] [nvarchar] (4),
[REFNUM] [nvarchar] (10),
[INVNUM] [nvarchar] (10),
[CDATE] [datetime] NULL ,
[ENTDATE] [datetime] NULL
) ON [PRIMARY]
GO