SQL Server and Access with different data

[Leesha]

Hi,
I have a database that is linked to sql server 2005 tables. The access queries are running fine. However, when I run a query to look at the same data using sql server 2005, the data related to time doesn't show up. I can see it if I open the tables directly, I can see it in the Access query, but it doesn't show in sql query. The sql server query is being used for data on the internet so I do need to use it.

I'm not sure what to look at first.

Thanks,
Leesha

[geedeearr]

Hi Leesha,
Would you please post the sql of both queries?
Thanks.

[Mark L]

Hi,
I have a database that is linked to sql server 2005 tables. The access queries are running fine. However, when I run a query to look at the same data using sql server 2005, the data related to time doesn't show up. I can see it if I open the tables directly, I can see it in the Access query, but it doesn't show in sql query. The sql server query is being used for data on the internet so I do need to use it.

I'm not sure what to look at first.

Thanks,
Leesha

I don't know how much experience you have running a View from within SQL Server, so I don't know whether or not you realize that there are some major syntax differences between SQL statements there vs. Access. For example:
    Access: OrderDate <= #03/11/10#
    SQL:     OrderDate <= '03/11/10'

[Leesha]

Hi,

The access sql is as follows:
SELECT dbo_tblTimeSheet.TimeSheetID, dbo_tblTimeSheet.EmployeeName, dbo_tblTimeSheet.KeyCode, dbo_tblTimeSheet.Date, dbo_tblTimeSheet.StartTime, dbo_tblTimeSheet.EndTime, dbo_tblTimeSheet.TownDistrict, dbo_tblTimeSheet.WeekEndingDate, dbo_tblTimeSheet.StudentName, dbo_tblTimeSheet.Closed
FROM dbo_tblTimeSheet



The sql server sql is:

SELECT TimeSheetID, EmployeeName, KeyCode, Date, StartTime, EndTime, TownDistrict, WeekEndingDate, TimeSheetComments, StudentName FROM tblTimeSheet

[PatriciaW]

Leesha -- I don't see any WHERE clause, so -- just not sure, but is it the "Closed" field that you are missing? because it is not being called for in the sql server sql. ??
Pat