Yup, but a little counter-intuitive for someone with speed in mind.  It does appear that the data is agregated twice when in fact it's done only once

Also this would run MUCH MUCH faster :

Insert into DbName.dbo.Tablename (col1, col2, coln) Select Col1, Col2, Coln from Db2.dbo.TableName.

Open up the profiler and run this code.  Grad the insert statement sent by access.  Then rerun it in query analyser.  You should get a more usefull error message.

I would...

You can't refference the count(*) using the column name.  You must do something like this :

Select count(*) AS Cnt, sum(ColName) As Total, sum(ColName) / Count(*) as Average

from...

We've all been there .

Please do not cross-post.  We lessen your chances of getting the right answer faster by doing so.

Finish this thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=324845

HTH .

What authentication mode are you using?

What login are you using in the connection string??

I use the user_name method and it doesn't give dbo for all the users (for me only...

Does this answer your question?

IF NOT EXISTS (SELECT * FROM dbo.SysObjects WHERE Name = 'TestIDIns' AND XType = 'U')

       BEGIN

               CREATE TABLE dbo.TestIDIns

               (

                         ID INT NOT NULL IDENTITY(1,