If adhoc queries would be permitted, your original select will most likely work.

I personally haven't any experience querying access tables through sql server.

Vijay, mind to share the solution for future reference?

You can find a list of connectionstrings at

http://www.connectionstrings.com/

Can be a standalone server without a domain.

For windows authentication it needs a domain except if you run the application on the server itself.

See the books online (sql server help...

Is the database being protected by access user security?

In this case you probably have to copy the mdw file to your sql server.

A Workgroup Information File (*.MDW) stores information to...

Looks they have service pack 4 of sql server where the issue should be resolved.

If adhoc queries of your access databases isn't allowed, you can still refer to them if...

cvsql1\administrator should be correct

My account in SQLServerAgent service got abbreviated to

.\administrator

I hope this helps.

if the number of transactions isn't too great.

SELECT StockTransactions.StockID

,ISNULL(Tran1.AvgAmount,0) AS AvgAmountforTransactionid1 ,ISNULL(Tran2.AvgAmount,0) AS AvgAmountforTransactionid2

from ( /*All distinct StockIDs to join*/

select distinct StockID

from test.dbo.StockTransactions StockTransactions

) StockTransactions

left join /*Calculate transaction 1 */

(SELECT...

Normally it is computername\administrator.

You can find a valid list of users in usermanagement in windows.

(Start->Settings->Control Panel->Users & Passwords)

Can you change the sql agent service account to the administrator account instead of NT AUTHORITY\SYSTEM? So far I know local system account has no rights on any networking stuff.

If you...

Starting the profiler and tracing for any delete / truncate table / drop table statements?

What sql server version are they running and what is their service pack?

It might be a bug that was resolved in sql server 2000 sp 3

more info:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;328569

you can use a left join / inner join

if

SELECT picks.name AS Name, Count(picks.name) AS [Days Picked], Avg(picks.gain) AS [Week 1 Avg Gain]

FROM picks

WHERE (((picks.entrydate)>=#1/3/2005#) AND ((picks.entrydate)<=#1/7/2005#))

GROUP BY picks.name

ORDER BY Avg(picks.gain)...

I have no experience with adp-projects.

But probable you need to restore /attach/recreate the TimeandBill, Robin databases on your sql server.

There is nothing in the book or on the cd that provides...

Varchar will only store the actual data removing trailing white space, conserving diskspace in the process.